Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
91 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
72 | |
60 | |
59 |