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?