Forum Discussion

amani1980's avatar
amani1980
Frequent Visitor
1 year ago
Solved

Rank based on measure

Hello,   I have an issue with my PBI model where I'm trying to rank people based on a measure. I have calculated rank using RANK function. However, rankings do not change when I toggle between year...
Need Help
  • amani1980's avatar
    amani1980
    1 year ago

    Thanks for the replies!

     

    I was fumbling with RANKX for nearly a day and then stumbled upon RANK by accident (here in this forum) and it worked by accident and I didn't even realize it.

     

    Rank Measure = RANK(DENSE,ALL(Names),ORDERBY([Measure],DESC),,)

     

    Appreciate your time!