Negating the IN Operator

Hi aiton_grant 

Try below:

Customers measure = 
CALCULATE(
    DISTINCTCOUNT('Purchase FACT'[Customer ID]),
    FILTER(
        VALUES('Purchase FACT'[Customer ID]),
        VAR HasBikeOrScooter = 
            CALCULATE(
                COUNTROWS('Purchase FACT'),
                'Product Detail'[Product Category] IN {"BIKE", "Scooter"}
            ) > 0
        VAR HasCar = 
            CALCULATE(
                COUNTROWS('Purchase FACT'),
                'Product Detail'[Product Category] = "CAR"
            ) > 0
        RETURN
            HasBikeOrScooter && NOT(HasCar)
    )
)

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

Hi aiton_grant ,

I think you want to count the customers that never had bought any car. So you can write a measure as follows: