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.
Hello,
In my company we create contest for our managers. I need to displey resoults. I allready created measure whitch counts managers score and the score components.
Now I need to create measure with manager current place in competition. Manager after choosing their name on slicer should see their resoult (points), components but primaly his position in contest.
Please help
Solved! Go to Solution.
hi, @Lokisame
You could use RANKX Function to create your expected measure as below:
Ranking = RANKX(ALLSELECTED(Table1),CALCULATE(SUM(Table1[Score])),,DESC)
Result:
Best Regards,
Lin
hi, @Lokisame
You could use RANKX Function to create your expected measure as below:
Ranking = RANKX(ALLSELECTED(Table1),CALCULATE(SUM(Table1[Score])),,DESC)
Result:
Best Regards,
Lin
Thank you 🙂 You help me a lot.
Maybe you know how add to this query a filter? Not all of managers are taking part in this competition. For example i have table with managers with their ID and status - I need to create ranking only for managers with status 1 and eliminate status 2,3...
Additionaly is it posoble to add the resoult of Rankx to manager name? - For exaple (1) Manager7, (2) Maneger3 - I need to use it on chart axis.
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |