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")

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
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")

yacine_Big's avatar
yacine_Big
Frequent Visitor
3 years ago

thank you it works like a charm, with some modifications because my table is more complicated than the one gave you but it really works thank you again .

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    3 years ago

    you are welcome