Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a set of Offices in my organization, divided in Groups, each Office keep track of its Operations.
I have to create a KPI that when I go in drilldown on a single Office it confronts its Operations with a Measure of Count(Operations)/Count(Offices) but only relative to the selected Office's Group, not all the Offices.
I tried creating a measure of this division but when i select the sigle Office the measure too is filtered to that, and if I make it ignore selections it considers all the Offices (all the Groups).
How can I make this measure ignore all the selection filters except the one regarding the selected Office's Group?
Thanks for the help.
Solved! Go to Solution.
Hi @Crysis85,
Please try this measure:
Divid measure = COUNT ( Offices[Operations] ) / CALCULATE ( COUNT ( Offices[Office] ), ALL ( Offices[Office] ) )
Regards,
Yuliana Gu
Hi @Crysis85,
Please try this measure:
Divid measure = COUNT ( Offices[Operations] ) / CALCULATE ( COUNT ( Offices[Office] ), ALL ( Offices[Office] ) )
Regards,
Yuliana Gu
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |