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]))
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%