Hierarchy Slicer Dax

[MYDATASTORY]

Hi, 

Kindly advice, I have Three columns I want to create hierarchy slicer so that when I select Subject I will be able to see all the relationship on hierarchy column Subject for example; I have added Hierarchy relationship for a reference purpose to show how the data flow on slicer perspective on the Subject column.

•  First 3 digit of code shows Parent relationship with subject i.e. 400=History, the second Part shows the child relationship 400-10= History Year 7 
• Question /help request:
• if I select History, I would like to see |History Year 7 |History Year 9 |History Year 11 | below History subject. I have used a hierarchy slicer but is not working well, the count should be 3 as there are three children below History subject.

Code:        Subject                     Hierarchy Relationship

400           History                      Parent                

400-10     History Year 7            Child

400-11     History Year 9            Child

400-12     History Year 11          Child

500          Maths                        Parent

500-10    Maths Year 11           Child 

500-12    Maths Year 12            Child

Thanks in advance

[amitchandak]

@MYDATASTORY , see if this can help. You might have use path

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

Refer
https://community.powerbi.com/t5/Desktop/Dynamic-measure-calculation-for-hierarchy-data/td-p/592546
https://community.powerbi.com/t5/Desktop/How-to-create-column-and-row-hierarchies-in-tables/td-p/811...

[MYDATASTORY]

Much appreciated @amitchandak