Forum Discussion
KMichael99
2 years agoFrequent Visitor
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...
- 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!
KMichael99
2 years agoFrequent Visitor
Brilliant, this works - thanks!