Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
@Anonymous , Create this with +0
COUNTX(
FILTER(
SUMMARIZE('F-KPI OTIF' ,
'F-KPI OTIF'[AN customer group],
'F-KPI OTIF'[L1 business unit id],
'F-KPI OTIF'[Date (Month)],
"OTIF CCCB", if([% OTIF] >= 0.88, "1","0"),
"OTIF CSSTSA", if([% OTIF] >= 0.92, "1","0"),
"OTIF COP", "TBD")
[OTIF CSSTSA] = "1"),
'F-KPI OTIF'[AN customer group])
Or use option show item with no data