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

also to calculate the COUNT  you can do this:

 

LoyalCount = SUMX ( FILTER ( VALUES('Table'[Name]), [number of products] = 1 ), 1 )
DisLoyalCount = SUMX ( FILTER ( VALUES('Table'[Name]), [number of products] > 1 ), 1 )