Summarize columns and addmissingitems may not be used in this context

[Anonymous]

Good day!

This measure below return the erro with the subject, when I make other filter in visual, any solution for its?

measure =

COUNTX(

FILTER(

ADDMISSINGITEMS(

'F-KPI OTIF'[AN customer group],

'F-KPI OTIF'[L1 business unit id],

'F-KPI OTIF'[Date (Month)],

SUMMARIZECOLUMNS(

'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"),

'F-KPI OTIF'[AN customer group],

'F-KPI OTIF'[L1 business unit id],

'F-KPI OTIF'[Date (Month)]),

[OTIF CSSTSA] = "1"),

'F-KPI OTIF'[AN customer group])

tks,
Lucas

[amitchandak]

@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