Forum Discussion
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...
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)
Additionally, you can simplify your first measure to just
Total championships = COUNT(Champions[Champion])
Hope this helps.