Forum Discussion

TooOld's avatar
TooOld
Frequent Visitor
4 years ago
Solved

RANKXX problem

I'm working on a result report on sport activities. Data source is a SQL server database. The report shall show results in a table based on field parameter slicer Ranking  - Daily - Weekly -Mo...
Rankx with filter
  • TooOld's avatar
    TooOld
    4 years ago

    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