Rank based on measure

[amani1980]

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 years using a slicer. It always shows the same rank (which is computed for all years) regardless of which year I select in the slicer. PBI Model here.

Can someone help me how to dyanmically rank based on a measure?

Thanks in advance,

AM

[amani1980 · Accepted solution]

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! 

[Anonymous]

Hi @amani1980 ,

Please mark your answer as a solution.

Best Regards

[ribisht17]

HI @amani1980 

Are you sure ?

It works as expected,

Here is my video on Power BI rank function https://youtu.be/IlB3Ezlrmro 

Regards,

Ritesh

Please mark the answer if it is helpful so that it can help others as well

Dance-Sing with Data Projects - YouTube

[Bibiano_Geraldo]

Hi @amani1980 ,

Based on your .pbix, your measure is working perfectly, as you can see in your table, when change the selection in the slicer the names are rearranged based on your Rank measure.

[Ritaf1983]

Hi @amani1980 
It seems that the formula works as expected....

The pbix with the simulation is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[lbendlin]

Please read: https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/