Forum Discussion
Service Level KPIs
I need to create a bunch of Service Level KPIs. They will need to incorporate filters like status and type but what they all have in common is that the Report Month needs to match the slicer setting...
Hi PBI_Curious ,
Here are the steps you can follow：
1. Create a calendar
Date = CALENDARAUTO()2. Create measure.
Measure =
var _select=SELECTEDVALUE('Date'[Date])
return
IF(_select=MAX('Table1'[Report Month])&&MAX('Table1'[Opened])>=_select&&MAX('Table1'[Opened])<=_select+1,1,0)3. Place the measure in the Filter and select Apply Filter.
4. Result：
Regarding the Service Level formula, because of the Excel statement you used, can you explain the specific logic, so that it is better for me to help you:
You can downloaded PBIX file from here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.