Forum Discussion

Chas3's avatar
Chas3
New Member
3 years ago

SLA Report

Hi all,

 

I'm very new to Power BI and in need of some help.  

 

I need to created a report to show % of processes that where completed in SLA by class.  

 

The multiple 'process' are grouped under 'class'.  'SLA-Status' is recorded for each 'process' as either 'In SLA' or 'Missed SLA'. If any one of the processes in the class has 'Missed SLA' then the whole class is missed SLA.  

I'm struggling to write thre measure, any help appreciated. 

thanks

Bob

Need Help
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Chas3 , Create a measure like

     

    Measure =
    var _count = calculate(count(Table[class]), filter(Table, Table[SLA Satus] ="Missed SLA"))
    return
    countx(values(Table[process]), calculate(if(isblank(_count), [process], blank())))

    • Chas3's avatar
      Chas3
      New Member
      3 years ago

       Thanks for coming back to me.  I tried your measure but hit a synced error.  Any advice?