SLA calculation

[ashaikh]

Hello Guys,

I have a scenario here;

I need to calulate SLA percentage based on the Priority.

I have 3-columns:

1. Has Met SLA - Says if it has met SLA
2. Priority - Priority
3. Ticket Id - Id of a ticket.

Now SLA is calulated as count of ticket for which priority a has met divided by total count of ticket for that priority

Example

For Priority: Low

Total Tickets: 100

Has Met SLA : 95

Has not met SLA: 5

SLA Percentage: 95%

I need help with DAX calculation how will i get the SLA percentage.

[fhill]

Is your Has Met SLA YES/NO (text) or 0/1 (bit)?

[ashaikh]

Its a text. Yes/No

[fhill]

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)

[ashaikh]

will the percentage be same if I have SLA CHeck column in visual?

[fhill]

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

[ashaikh]

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%

[fhill · Accepted solution]

Tickets = COUNT(Table1[Ticket ID])

SLA%_2 = COUNT(Table1[SLA_Check - Text]) / CALCULATE(COUNT(Table1[SLA_Check - Text]), ALL(Table1[SLA_Check - Text]))

[ashaikh]

Thanks.

That works.

[fhill]

Ignore my 0/1 column, I was building that direction until I got your reply. Forrest