Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 Positional Maximum Speed Rank. Here's my current DAX, which works correctly:
Solved! Go to Solution.
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!
Brilliant, this works - thanks!
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!
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
24 | |
22 |