Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
2 years ago

Calculation New, Repeat Customer

Hi BI Community Team,   I have a sales order table (Aug'23 till Oct'23), with this I have created a measure below to find the customer purchased:   Customer Purchased = CALCULATE(DISTINCTCOUNT('...
Need Help
ADSL's avatar
ADSL
Post Prodigy
2 years ago

Hi Ashish_Mathur,

 

I have checked your file, the number is more than I count manually in excel.

 

This result is distinct count in excel file.

 

Please check and advise.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    How do you expect me to help you with just that statement.  DIY.  Solve it by yourself now.

  • ADSL's avatar
    ADSL
    Post Prodigy
    2 years ago

    Hi Ashish_Mathur,

     

    Just feedback what I see however still need your support and advise. sometimes we misunderstand or wrong explain then result also are different.

     

    Thanks and Regards,

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    I really do not know how ealse to help you.  Create a small dataset and try my formulas on that small dataset.  See if you get the perfect result there or not.  If there is a problem even on that small dataset, then we will revise the formula.  Finally we will then plug in your large dataset.  Please send time on doing this checking yourself.

  • ADSL's avatar
    ADSL
    Post Prodigy
    2 years ago

    Hi Ashish_Mathur ,

     

    Well noted. Thank you very much for your value time and help.

     

    Best Regards,