Forum Discussion

jjasper's avatar
jjasper
Icon for Helper II rankHelper II
5 years ago
Solved

Rankx not ranking correctly

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
 
  • It looks like you might have a text mismatch (e.g. "til" versus "till").

2 Replies

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

    • jjasper's avatar
      jjasper
      Icon for Helper II rankHelper II

      Thank you! That was the issue.