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
Resolver IHi 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 - expectedWeekly 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