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.
Hey everyone!
I have tried every combination of calcs and measures to get this to work but to no avail.
What I'm trying to achieve is a set of 4 KPI visuals that have the % Achieved values based on priority 1-4 and to change based on the filtered assignment group (firm wide). As the example table shows, any idea how I can achieve this please!! Pulling my hair out 😞 Thanks!
Assignment Group | Status | Priority | SLA % |
A | Achieved | 1 | |
A | Breached | 1 | |
A | Achieved | 2 | |
A | Achieved | 3 | |
B | Breached | 1 | |
B | Achieved | 4 | |
B | Achieved | 4 | |
B | Achieved | 3 | |
B | Breached | 2 | |
B | Breached | 2 | |
C | Achieved | 1 | |
C | Achieved | 3 | |
C | Achieved | 1 | |
C | Breached | 4 | |
C | Breached | 2 |
Hi @mshamsiev
Do you want the % of SLA to add up to 100 across all your data?
Or do you want it to be based on the Priority?
This will give you the % SLA no matter which fields you drag into your data.
NOTE: Change Table1 to your tablename
% SLA = DIVIDE ( COUNTROWS ( 'Table1' ), CALCULATE ( COUNTROWS ( 'Table1' ), ALL ( Table1 ) ) )
Hey again 🙂 Thanks for the reply.
I'm aiming to have 4 buttons (KPIs), each will be filtered by P1-P2-P3-P4. On the side of the dashboard I have a filter with assignment groups. What I'd like is for each of the 4 visuals to present the % Achieved SLA for the selected assignment group or if I deselect the filter for a firm wide SLA for each priority. Thanks again!
Eg. p1 SLA % Achieved p2 SLA % Achieved etc.
98% 66%
Target: 95% (+3%) Target: 95% (-29%)
hi @mshamsiev
Thanks for that, but in terms of how you get to the % of SLA are there specific statuses that would define what makes it up?
So for example how would I get the % SLA for P1?
Ahh! Sorry. So the way in which I set it up in excel was to ustilise sumifs filtering on both assignment groups and priority. So total achieved per assignment group per priority divided by the total incidents for that specific assignment group/priority.
However, in Power BI I assumed we could use the 'visual level filter' for each of the 4 visuals and filter based on the priorities?
Hope this makes sense. I can send a snapshot of my excel setup if that helps.
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 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |