Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I use a RankX measure to calculate the Rank of different values.
This works fine but in addition to that Information I want to show the place in the ranking, i.e. Rank X from Y.
But I could'nt find a DAX that I can use to calculate the Y.
Does anybody have an Idea ?
Solved! Go to Solution.
Try this pattern
Measure MaxRank= MAXX ( ALLSELECTED ( TableName[Team] ), [RankMeasure] )
Hi BileMG ,
What does "place in the ranking" and "Rank X from Y" mean? Could you please clarify more details about your expected result?
Regards,
Jimmy Tao
Hi,
my current measue calculate the Rank of Sales in a team and in a period. I show it in a card, for example the Sales of BileMG is 30K, he is on Rank 5 of ? ?. This figure makes more sense, when I also could show the place in the Rank. Rank 5 of 30 has another impact ob performance that he ist on Rank 5 of 5.
Try this pattern
Measure MaxRank= MAXX ( ALLSELECTED ( TableName[Team] ), [RankMeasure] )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |