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,
we create contest in our company and i want to show resoults.
Our managers and their offices are collect points. One manager have many offices. For example:
Manager1 - 50 points (their offices: Office1 - 30 points, Ofiice2 - 10points)
Manager 2 - 70 points (Office3 - 20 points, Office4 - 5ponts)
Soo the rank look line this:
1. Manager2
2. Manager1
1. Office1
2. Office3
3. Office2
4. Offce4
And this was easy part - I used "Ranking = RANKX(ALL(Table1),CALCULATE(SUM(Table1[Score])),,DESC)" all works good.
But i need to show this on chart and when i drill down Manager to see their offices I need to keep this resoults. For exaple:
When i drill manager2 i see Place 1- Office 3, Place 2 - Office4 - It should be Office3 - place2 and Office4 - place4.
It is posoble to do this? Please help and sorry for my english.
Solved! Go to Solution.
Hi @Lokisame ,
One sample for your reference. We can create two measures to get the excepted result.
scorem = CALCULATE(SUM(Table1[Score]))
Measure = IF(ISINSCOPE(Table1[Office]),RANKX(ALL(Table1),[scorem],,DESC),RANKX(ALL(Table1[Manager]),[scorem],,DESC))
Please find the pbix as attached.
Regards,
Frank
Hi @Lokisame ,
One sample for your reference. We can create two measures to get the excepted result.
scorem = CALCULATE(SUM(Table1[Score]))
Measure = IF(ISINSCOPE(Table1[Office]),RANKX(ALL(Table1),[scorem],,DESC),RANKX(ALL(Table1[Manager]),[scorem],,DESC))
Please find the pbix as attached.
Regards,
Frank
Hi @Lokisame ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |