Rankx not working correctly

[Anonymous]

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 championships =

CALCULATE(COUNT(Champions[Champion]), ALL('Date'), 'Date'[Date] <= MAX('Date'[Date]))

The Rank formula is:

Rank champions =

RANKX(ALL(Champions),[Total championships],,DESC, Dense)

The result is this:

[Anonymous]

Thanks! That worked. 

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

[Ashish_Mathur]

Additionally, you can simplify your first measure to just

Total championships = COUNT(Champions[Champion])

Hope this helps.

[aadatapro · Accepted solution]

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)