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
Icey's avatar
Icey
Community Support
4 years ago

Hi TooOld ,

 

Based on my test, your measure works. Do you mean you want to modify the expression? If so, try this:

mRankOnFilterActyVolts 2 =
IF (
    HASONEVALUE ( RfvRefined[TotalCalculatedPower] ),
    RANKX (
        ALLSELECTED ( RfvRefined ),
        CALCULATE ( MAX ( RfvRefined[TotalCalculatedPower] ) )
    )
)

In addition, if you just want to show the top1 value in the table visual, you can set filter like so:

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • TooOld's avatar
    TooOld
    Frequent Visitor
    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