title: Usage of Power BI Interactive visualisations with Parent-Child dataset relations
body: <p>I have been meddling with Power BI for almost a week now.
  It seems like a powerful tool, when you get to know your way around it at least..</p>
  
  <p>I would like to be able to see the sum of Therapists, Admins and Citizens, based on all subgroups for the currently selected group.</p>
  
  <p>Here is my example:
  <a href="https://i.stack.imgur.com/MwKBv.gif" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MwKBv.gif" alt="enter image description here"></a>
  When i select a Group (resembling a customer group) in the Drill Down Donut Chart, i want so see admins, therapists, and citizen count for all subgroups in the selected group, shown in the Clustered Column Chart. However I only get the users which are in the selected group, and not the users in sub groups.</p>
  
  <p>I have created measures for Admins, Therapists &amp; Citizens to get the count based on TemplateLevel (which is resembling the role of the user:
  <a href="https://i.stack.imgur.com/wQ6c2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wQ6c2.png" alt="enter image description here"></a>
  All measures are written in the same fashion, using different TemplateLevel(s).</p>
  
  <p>Here is the three measures used in the Column Chart:
  <a href="https://i.stack.imgur.com/lTAWz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lTAWz.png" alt="enter image description here"></a></p>
  
  <p>In my DataSet, i have the table UserGroup: 
  <a href="https://i.stack.imgur.com/fIA9W.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fIA9W.png" alt="enter image description here"></a>
  IdPath and NumLevels is an attempt to use parent-child reference, which i did not get to work properly, so dont mind that.
  I expected that Power BI's interactive system would be able to handle Parent/Children references, as is the case with UserGroup[Id] and UserGroup[UserGroupParentId]. My initial thoughts was to just add GroupName as Category for each level of SubGroup available (Owner -> Customer -> Therapist -> Citizen).</p>
  
  <p>Owner group id is 27 and always will be so that's why the drill down donut chart is filtering groups with no such parent it, to show the customer groups.</p>
  
  <p>The DataSet for the report is from a test database migrated to an Azure SQL Server.</p>
  
  <p>Any suggestions are given the warmest welcome!</p>
  
  <p>Kindly Regards
  Kalrin</p>