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 yes it goes up to 4 decimals, as I mentioned, better to use the RANK function and yes you can use it for measures, not sure where you get that this cannot be used for measures. You can absolutely use it!