Forum Discussion
RANKXX problem
Hello Icy
my formula didn't work on further subfilter like , Gender and Country/Nation. The correct solution is_max =CALCULATE (MAX ( RfvRefined[TotalCalculatedPower] ),ALLSELECTED ( RfvRefined ),VALUES ( RfvRefined[UserName]))_mRank =RANKX ( ALLSELECTED ( RfvRefined ), [_max],, DESC,Dense)
I thank you for contribution. I still work on further ranking results, like
Average by 6 best results in a month for each user
Best Chris
Hi TooOld,
Could you show the output you want?
Best regards.
At time I got the result
| Weekly Rank | UserName | Gender | Age | Nation | ActyVolts | Subfilter |
| 1 | Jerms | M | 36 | IT | 7896 | 1 |
| 2 | Ajas | F | 33 | CH | 6706 | 2 |
| 3 | Arlind | F | 27 | CH | 5697 | 3 |
| 4 | Sepp | M | 57 | CH | 3200 | 6 |
| 5 | Soldo | F | 40 | DE | 245 | 9 |
The Column Weekly Rank represents the overall ranking of the username based on column ActyVolts. Weekly Rank = Overall Ranking (Done in SQL Server)
The Column Subfilter shall show different rankings based on slicer and not change the Weekly Ranking
- Nation
- Gender
No Gender or Nation filter from slicer set - expected
| Weekly Rank | UserName | Gender | Age | Nation | ActyVolts | Subfilter |
| 1 | Jerms | M | 36 | IT | 7896 | 1 |
| 2 | Ajas | F | 33 | CH | 6706 | 2 |
| 3 | Arlind | F | 27 | CH | 5697 | 3 |
| 4 | Sepp | M | 57 | CH | 3200 | 4 |
| 5 | Soldo | F | 40 | DE | 245 | 5 |
Gender set to Women Only (Slicer Gender set to F))
| Weekly Rank | UserName | Gender | Age | Nation | ActyVolts | Subfilter Nation = F (Female) |
| 2 | Ajas | F | 33 | CH | 6706 | 1 |
| 3 | Arlind | F | 27 | CH | 5697 | 2 |
| 5 | Soldo | F | 40 | DE | 245 | 3 |
Nation set to 'CH' (Slicer Nation)
| Weekly Rank | UserName | Gender | Age | Nation | ActyVolts | Subfilter Nation = CH (Slicer) |
| 2 | Ajas | F | 33 | CH | 6706 | 1 |
| 3 | Arlind | F | 27 | CH | 5697 | 2 |
| 4 | Sepp | M | 57 | CH | 3200 | 3 |
To sum up
In Sports there is an overall ranking for a contest, but participants expects to see a filtered ranking
- Women
- Nation
- AgeGroup
I thank you for helping here out