Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
78 | |
72 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |