Forum Discussion

wjenkins3811's avatar
wjenkins3811
Frequent Visitor
8 years ago
Solved

rank

Hello,   I am trying to change the way my ranking is displaying.  #7 in the Ranking 3 column I would like to show as #2, 3, 4, 5, 5, etc..  Here is the measure I currently have: Ranking 3 = RANKX...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    Try adding dense at end end of the rankx function, check the syntax.

     

    Ranking 3 = 
RANKX(ALL(Pre_Calibrated[reviewer_name]),
CALCULATE(SUM('Pre_Calibrated'[Count Correct])/COUNT('Pre_Calibrated'[Correct Answer]))
,,, Dense
)
parry2k's avatar
parry2k
Super User
8 years ago

Try adding dense at end end of the rankx function, check the syntax.

 

Ranking 3 = 
RANKX(ALL(Pre_Calibrated[reviewer_name]),
CALCULATE(SUM('Pre_Calibrated'[Count Correct])/COUNT('Pre_Calibrated'[Correct Answer]))
,,, Dense
)
wjenkins3811's avatar
wjenkins3811
Frequent Visitor
8 years ago

Thank you so much. Its working now.. I tried that earlier I guess I had a typo.