Forum Discussion

Sanju_BI's avatar
Sanju_BI
Frequent Visitor
3 years ago

Power BI - Ranking on a Matrix Visual

Have an issue, I've encountered with the Rank Measure used for our Parent and Child categories in Power BI visualizations. We have a Rank Measure in place that effectively calculates the ranks for o...
Need Help
Show and Tell
Tips and Tricks
Sanju_BI's avatar
Sanju_BI
Frequent Visitor
3 years ago

Here is my Measure, that i wrote for Ranking.
Rank =
VAR ismfFiltered = ISINSCOPE('Customer GP Data'[New MF Code & Parent Name])
VAR isCustFiltered = ISINSCOPE('Customer GP Data'[Customer Name & Code])

RETURN
SWITCH(
TRUE(),
AND(ismfFiltered, NOT(isCustFiltered)),
IF(
COUNTROWS('Customer GP Data') > 0,
RANKX(
FILTER(
ALLSELECTED('Customer GP Data'[New MF Code & Parent Name]),
[Total Est GP] > 0
),
[Total Est GP],
,
DESC,
Dense
),
BLANK()
),
isCustFiltered,
IF(
COUNTROWS('Customer GP Data') > 0,
RANKX(
FILTER(
ALLSELECTED('Customer GP Data'[Customer Name & Code]),
[Total Est GP] > 0
),
[Total Est GP],
,
DESC,
Dense
),
BLANK()
),
BLANK()
)

pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Sanju_BI  , have you created heirarchy for the parent and child columns ?
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