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]))
Hope this helps...
Measures:
Tickets = COUNT(Table1[Ticket ID]) // ALL Tickets (In a Table, Power BI automatically groups by values (i.e. Priority)
Pass_SLA = CALCULATE(COUNT(Table1[SLA_Check - Text]), // Counts # of Tickets
Table1[SLA_Check - Text] = "YES") // Filtering for only "YES"
SLA% = [Pass_SLA] / CALCULATE(COUNT(Table1[SLA_Check - Text]), ALL(Table1[SLA_Check - Text]))
// The ALL brings back in ALL values, but still maintains the Table Measures (grouping i.e. Priority)
Ignore my 0/1 column, I was building that direction until I got your reply. Forrest