Rankx not ranking correctly

[jjasper]

Hello, 

I have a leaderboard that I have created and I have one event that is not being ranked correctly. I am using the same formula for each event just changed the filter. All other events are working but one. 

Here is the formula I am using as well as photo of the leaderboard. As you can see all the other ones are working correctly but not the Shake it till U make it on. 

SHake it = RANKX(FILTER(VillageChampionships, VillageChampionships[Event] = "Shake it till U Make It"), VillageChampionships[Score], VillageChampionships[Score],DESC,Dense)

Showing how both formulas are the exact same. 

Marathon Rank = RANKX(FILTER(VillageChampionships, VillageChampionships[Event] = "Marathon"), VillageChampionships[Score], VillageChampionships[Score],DESC,Dense)

Any help is greatly appricated. 

TIA

[AlexisOlson · Accepted solution]

It looks like you might have a text mismatch (e.g. "til" versus "till").

[jjasper]

Thank you! That was the issue.