Forum Discussion

ashaikh's avatar
ashaikh
Helper 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
Resident Rockstar
9 years ago

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

ashaikh's avatar
ashaikh
Helper III
9 years ago

Its a text. Yes/No

  • fhill's avatar
    fhill
    Resident 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)

     

    • fhill's avatar
      fhill
      Resident Rockstar
      9 years ago

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

    • ashaikh's avatar
      ashaikh
      Helper III
      9 years ago

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

      • fhill's avatar
        fhill
        Resident 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