Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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())))
Thanks for coming back to me. I tried your measure but hit a synced error. Any advice?