Forum Discussion

ashaikh's avatar
ashaikh
Helper III
8 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
    8 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
8 years ago

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

  • ashaikh's avatar
    ashaikh
    Helper III
    8 years ago

    Its a text. Yes/No

    • fhill's avatar
      fhill
      Resident Rockstar
      8 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
        8 years ago

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