Forum Discussion
jjasper
Helper II
5 years agoRankx 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
- AlexisOlson
Super User
It looks like you might have a text mismatch (e.g. "til" versus "till").
- jjasper
Helper II
Thank you! That was the issue.