VAR Mix_Min_1_9_CKs =
VAR vTab =
FILTER(
SUMMARIZE(
'Base Sell Out',
'Base Sell Out'[CPF/CNPJ PDV],
PDV[Canal Consolidado],
PDV[Segmento do PDV]
"@QTD_CNPJ",
DISTINCTCOUNT('Base Sell Out'[1-9 CKs])
),
CALCULATE(
DISTINCTCOUNT('Base Sell Out'[1-9 CKs]) = 5,
'Base Sell Out'[1-9 CKs] IN {"CANETA BIC", "LIGHTER", "SOLEIL", "COMFORT 3 OU BIC3","BIC SENSITIVE OU COMFORT TWIN"}
)
)
RETURN
COUNTROWS(vTab)