Forum Discussion
Chas3
3 years agoNew Member
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 u...
amitchandak
3 years agoSuper User
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
3 years agoNew Member
 Thanks for coming back to me. I tried your measure but hit a synced error. Any advice?