Forum Discussion

DFPRO's avatar
DFPRO
Frequent Visitor
2 years ago
Solved

RANX returning Multiple Ranks for Same Value

A seemingly simple rankx measure is not returning the values I would expect, and I have tried everything to figure out the issue.    I have a table of Scores per Person, where each Person may have ...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    DFPRO I have seen in the past, it is usually because of the decimal numbers rounding, try using following code or I would recommend use new RANK function, but first try with this

     

    rankx(allselected(Table[Names]),CURRENCY([Average]),,desc,Dense)
parry2k's avatar
parry2k
Super User
2 years ago

DFPRO I have seen in the past, it is usually because of the decimal numbers rounding, try using following code or I would recommend use new RANK function, but first try with this

 

rankx(allselected(Table[Names]),CURRENCY([Average]),,desc,Dense)
DFPRO's avatar
DFPRO
Frequent Visitor
2 years ago

parry2k thank you for the recommendation. This solution works, however I have concern over the rounding. Does currency() round to the 5th decimal point? I worry that there may be instances where this causes issues, and would prefer to round to the 10th or higher decimal, for example. However, based on my current data, it works correctly. 

 

I thought that RANK() could not be used to rank measures, only columns? In this case, I cannot use RANK(), but only RANKX().