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(ALL(Pre_Calibrated[reviewer_name]),CALCULATE(SUM('Pre_Calibrated'[Count Correct])/COUNT('Pre_Calibrated'[Correct Answer])))

count correct is a  calculated column

Thank you

 

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
)

2 Replies

  • 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.