SLA % Calculations

Question

Hey everyone!&nbsp;I have tried every combination of calcs and measures to get this to work but to no avail.&nbsp;&nbsp;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&nbsp;table shows, any idea how I can achieve this please!! Pulling my hair out :( Thanks!&nbsp;Assignment GroupStatusPrioritySLA %AAchieved1&nbsp;ABreached1&nbsp;AAchieved2&nbsp;AAchieved3&nbsp;BBreached1&nbsp;BAchieved4&nbsp;BAchieved4&nbsp;BAchieved3&nbsp;BBreached2&nbsp;BBreached2&nbsp;CAchieved1&nbsp;CAchieved3&nbsp;CAchieved1&nbsp;CBreached4&nbsp;CBreached2&nbsp;

gilbertq · Answer

Hi&nbsp;mshamsiev&nbsp;Do you want the % of SLA to add up to 100 across all your data?&nbsp;Or do you want it to be based on the Priority?

gilbertq · Answer

This will give you the % SLA no matter which fields you drag into your data.NOTE: Change Table1 to your tablename&nbsp;% SLA =
DIVIDE (
    COUNTROWS ( 'Table1' ),
    CALCULATE ( COUNTROWS ( 'Table1' ), ALL ( Table1 ) )
)

mshamsiev · Answer

GilbertQ,&nbsp;Hey again :) Thanks for the reply.&nbsp;&nbsp;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!&nbsp;Eg. &nbsp; &nbsp;p1 SLA % Achieved &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p2 SLA % Achieved &nbsp; &nbsp; &nbsp; &nbsp; etc.&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 98% &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;66%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Target: 95% (+3%) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Target: 95% (-29%)

gilbertq · Answer

hi&nbsp;mshamsiev&nbsp;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?

mshamsiev · Answer

GilbertQ,&nbsp;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.&nbsp;&nbsp;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? &nbsp;&nbsp;Hope this makes sense. I can send a snapshot of my excel setup if that helps.&nbsp;

Forum Discussion

SLA % Calculations

6 Replies

Related content

SLA calculation

SLA calculation - filter statuses->assign SLA Y/N -> calculate SLA%

SLA Calculation

SLA Calculation weight by country

SLA calculation

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