Forum Discussion

ashaikh's avatar
ashaikh
Icon for Helper III rankHelper III
9 years ago
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 ...
Need Help
  • fhill's avatar
    fhill
    9 years ago

    Tickets = COUNT(Table1[Ticket ID])

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

     

fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
9 years ago

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's avatar
ashaikh
Icon for Helper III rankHelper III
9 years ago

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

  • fhill's avatar
    fhill
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

    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's avatar
      ashaikh
      Icon for Helper III rankHelper III
      9 years ago

      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's avatar
        fhill
        Icon for Resident Rockstar rankResident Rockstar
        9 years ago

        Tickets = COUNT(Table1[Ticket ID])

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