Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
7 years ago
Solved

Column Calculation not get right

Hi All ,    I have such below Table , Column of Purchase/No PUrchase ; Count are calculated in Edit Query , as of result this is the table  :  Customer Code  Customer Name  Date Value  Purc...
Show and Tell
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Chanleakna123 

     

    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's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Chanleakna123 

 

You may try create measure like below.If it is not your case,please share the .pbix file for us to test.You can upload the .pbix file to OneDrive and post the link here or send me via private message. Do mask sensitive data before uploading.

Repurchased Count =
CALCULATE (
    DISTINCTCOUNT ( 'Energy Drink'[Customer Code ] ),
    FILTER (
        ALLSELECTED ( 'Energy Drink'[Customer Code ] ),
        [RE-Purchased1] = "Repurchased"
    )
)

Regards,

Cherie

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Chanleakna123 

     

    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

  • Chanleakna123's avatar
    Chanleakna123
    Post Prodigy
    7 years ago

    Hi v-cherch-msft  you're brilliant , thanks for your quick help. 

  • Chanleakna123's avatar
    Chanleakna123
    Post Prodigy
    7 years ago

     

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

  • Chanleakna123's avatar
    Chanleakna123
    Post Prodigy
    7 years ago
    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