Return Customers which bought a specific product at least once

[Anonymous]

Hi!

I have the following star schema model. I want to create a measure which returns "Yes" if a customer has bought from  Product Group A at least once. Otherwise the measure should return "No". Can you please help me with this?

Thanks!

Please find the model attached.

The model

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

if(isblank(calculate(sum(FactQuote[Offered]), filter(Dimproduct, dimproduct[Product Group] ="Group A"))), "No", "Yes")

[Anonymous · Accepted solution]

Hi @Anonymous,

You can also try to use the 'filter' and 'countrows' functions to calculate with table records with specific conditions. After these functions calculated, you can add 'if statement' to compare the result value to return tags.
Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

if(isblank(calculate(sum(FactQuote[Offered]), filter(Dimproduct, dimproduct[Product Group] ="Group A"))), "No", "Yes")