Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear All,
I would like to have a 2 levels hierarchy matrix to show Top N item for second level hierarchy for each Group as following:
Is there any way to do so?
TIA
Solved! Go to Solution.
Rank =
var a = RANKX(ALLSELECTED('Column'[item]),[_Cost],,DESC,Dense)
var b = 'Top N'[Top N Value]
return
if(a<=b,1,0)
Hi @PowerBIOrg ,
You can resolve it using Parent-child hierarchies.
Please follow these link to read more about this :-
https://www.daxpatterns.com/parent-child-hierarchies/
https://learn.microsoft.com/en-us/dax/understanding-functions-for-parent-child-hierarchies-in-dax
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Proud to be a Super User!
Rank =
var a = RANKX(ALLSELECTED('Column'[item]),[_Cost],,DESC,Dense)
var b = 'Top N'[Top N Value]
return
if(a<=b,1,0)