SLA Report

[Chas3]

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

[amitchandak]

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

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