Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rankx not working correctly

Hello everyone,    I have a simple RankX function, but it's not working as expected. I want to rank F1 drivers with the most championship titles.    The formula for the titles is:  Total ch...
Need Help
  • aadatapro's avatar
    aadatapro
    4 years ago

    If you restrict your first parameter of the Rankx function to the column or columns you want to rank by, this should solve your issue e.g.
    RANKX(ALL(Champions[Champion]),[Total championships],,DESC, Dense)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks! That worked. 

Ashish_Mathur , thanks for your suggestion. I have an animated dashboard, so that's why I've added the filter context.