Forum Discussion

KMichael99's avatar
KMichael99
Frequent Visitor
2 years ago
Solved

RANK X with Filter

Hi,    I have a table called 'Player Reference' that has the following columns: Player Name, Position Group, Maximum Speed.    I am looking to rank the Maximum Speed column to provide a Positiona...
  • govindarajan_d's avatar
    2 years ago

    Hi KMichael99,

     

    Are you using SELECTEDVALUE to get the value of Position Group selected in the slicer?

     

    And I would suggest you use a variable to capture that value before using it in RANKX measure. 

    RankMeasure =
    VAR __PositionGroup = SELECTEDVALUE('2023-24 Player Reference'[Position Group])
    RETURN RANKX(
        FILTER(ALL('2023-24 Player Reference'),'2023-24 Player Reference'[Position Group] = __PositionGroup),
        CALCULATE(MAX('2023-24 Player Reference'[Season MV])))

     

    Upvote and accept as a solution if it worked!