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]))

     

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

  • ashaikh's avatar
    ashaikh
    Helper III
    8 years ago

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

    • fhill's avatar
      fhill
      Resident Rockstar
      8 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
        Helper III
        8 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%