Filter if customer bought certain products

[Anonymous]

Hello

I would like to be to be able to choose multiple products and then see if a customer had bought all selected products. 

Example: My table looks like this. 

I have a slicer with the Product name. When I choose lets say Bike and Car in the Slicer, I would like the Result to be Yes/No if that customer bought those two products or not.

Thanking you in advance

Client ID	Product Name
1	Bike
2	Bike
3	Car
1	Car
2	Car
1	Boat

[Syndicate_Admin]

Good morning Samarth

Thank you so much! It works great

Joe

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

Try to create a measure with below code:-

Bought(Y/N) =
IF (
    MAX ( 'Product'[Product Name] ) IN VALUES ( 'Product'[Product Name] ),
    "YES",
    "NO"
)

Output:-

Thanks,

Samarth

[Anonymous]

@Anonymous HI, where exactly you want to see yes/no is it for each row of customer name table or individually?

if you have any flag/identifyer to know if a customer purchased any product and then we can use this flag to create additional column for your purpose.

Regards,
John Basha Mattipati,
https://www.linkedin.com/in/john-basha-mattipati-06812980/