Forum Discussion
Solved
SLA calculation
Hello Guys, I have a scenario here; I need to calulate SLA percentage based on the Priority. I have 3-columns: Has Met SLA - Says if it has met SLA Priority - Priority Ticket Id - Id of ...
Tickets = COUNT(Table1[Ticket ID])
SLA%_2 = COUNT(Table1[SLA_Check - Text]) / CALCULATE(COUNT(Table1[SLA_Check - Text]), ALL(Table1[SLA_Check - Text]))
It doesn't look like it unless you filter to only include "YES' values... Please mock up what you want the final table to look like...?
FOrrest
Solution should be something like this
SLA Check Priority ticket count sla%
yes High 90 90%
no High 10 10%
yes low 75 75%
no low 25 25%