Help to count in measure

[andreasalleslev]

Hallo 

Hope somone can help me.

I have af measure, where I try to Count customers with non active product. but the measure also count customers if there have both Active and non Active - How can i only count the customers there only have non active product.

Customer without active product =

CALCULATE(

DISTINCTCOUNT(Ordre[customer_id]), FILTER(Linjer, [Aktive produkter] = BLANK())

)

Best regards Andreas

[amitchandak · Accepted solution]

@andreasalleslev , Try a measure like

Customer without active product =
CALCULATE(
Countx(filter( Values(Ordre[customer_id]), isblank([Aktive produkter])),[customer_id])
)

[andreasalleslev]

Thank you so much:-)