Forum Discussion
Column Calculation not get right
Please check below dax.
Count = CALCULATE ( COUNT ( 'Energy Drink'[Customer Name - Store host code] ), FILTER ( ALLSELECTED ( 'Energy Drink' [Customer Name - Store host code]), [Repurchased/No Repurchased]= SELECTEDVALUE('Re-Purchased/No Repurchased'[Type]) ) )Regards,
Cherie
v-cherch-msft , https://www.dropbox.com/s/79j0c729sa3khda/20191203-Category%20Report%20V3.pbix?dl=0
hi , you can go and check the link above ,
*My purpose is also to see how many Repurchased and No Repurchased. it is all filtered based on the data filtering.
Please check below dax.
Count =
CALCULATE (
COUNT ( 'Energy Drink'[Customer Name - Store host code] ),
FILTER (
ALLSELECTED ( 'Energy Drink' [Customer Name - Store host code]),
[Repurchased/No Repurchased]= SELECTEDVALUE('Re-Purchased/No Repurchased'[Type])
)
)
Regards,
Cherie
Hi v-cherch-msft you're brilliant , thanks for your quick help.
Hi v-cherch-msft , I do the calculation for another Purchase/No Purchase , And i follow the calculation of Repurchased/No Repurchased as per your mentioned.
but it's strang , Purchase/No PUrchase Calculation : Count only 2 Customers Who Purchase , but for customer who get 0 it will go to No Purchased , but it doesn't count into No Purhcase , it keeps blank . therefore i can't see the number of customer who Purchase and No Purchase , Purchase is customer value >=1 , No Purchase <1 .
***Purchased/No Purchased = SWITCH(TRUE(),[Sum Value]>=1,"Purchased","No Repurchased")***Count Purchased/No Purchased =CALCULATE (DISTINCTCOUNT ( 'Energy Drink'[Customer Name - Store host code] ),FILTER (ALLSELECTED ( 'Energy Drink' [Customer Name - Store host code]),[Purchased/No Purchased]= SELECTEDVALUE('Purchased/No Purchased'[Type])))- Can u please help to settle how to see the amount of Customer who purchase and no purchase on table ? While now no purchased customer show blank