Ranking the Resulting Values of Measures in Power BI

617 views Asked by At

Please help.

I am trying to create a dashboard (one-page) that shows KPIs of multiple groups. There are 10 groups and each group is represented with a box and the box is showing the group's %Compliance. Now, I want to add the RANK of this group's calculated measure Compliance (Format: Percentage) among the calculated measure Compliances of the 10 groups. See the syntax samples for the Compliance of each group.

ComplianceA = DIVIDE([CompletedA],[TotalA])

ComplianceB = DIVIDE([CompletedB],[TotalB])

ComplianceC = DIVIDE([CompletedC],[TotalC])

ComplianceD = DIVIDE([CompletedD],[TotalD])

. . .

All these measures are stored in one Table called RANKING.

I tried the RANKX function,

RANK GROUPA = RANKX(ALLSELECTED(RANKING),[ComplianceA])

RANK GROUPB = RANKX(ALLSELECTED(RANKING),[ComplianceB])

The results are all 1.

Can I rank the resulting values in measures?

1

There are 1 answers

0
cdespino On

Thank you guys. I found the formula on the web. I just need to modify the formula a little bit to customize it to my own table and measure names.

RANKING = RANKX(ALL(Table[Group]),CALCULATE(SUMX(PRMD,[Compliance])))

You can view the final result in my LinkedIn.

https://www.linkedin.com/posts/ciriaco-espino_i-recreated-my-ms-excel-dashboard-in-power-activity-6742056358167814144-H5d1

Thanks to mkRabbani and Mr. Alexis Olson for their time. Your replies encouraged me to find and search the web for the solution. I really appreciate your replies. Thanks.