Forum Discussion

yacine_Big's avatar
yacine_Big
Frequent Visitor
3 years ago
Solved

Calculate loyal customers

Hi i need help, i will try to explain my problem i hope someone can understand i have a table with many costumers and many products situation number one: a costumer who buys many products in same...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    yacine_Big 

    maybe you can create a new column

    loyalty = if(CALCULATE(DISTINCTCOUNT('Table'[products]),ALLEXCEPT('Table','Table'[ID Name],'Table'[category]))=1,"Y","N")

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

I corrected my file, please download it again

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://dropmefiles.com/6QKvt