Forum Discussion

Daro68's avatar
Daro68
Icon for Advocate I rankAdvocate I
5 years ago
Solved

Distinct count customers by turnover tresholds

Hey Community,   Looking for a link or a hint to solve following issue: I need to count the number of customers sorted by discount group and different tresholds of turnover.  F.ex: Customer disc...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Daro68 

    Please correct me if I wrongly understood your question.

    I tried to create a sample pbix file based on your explanation above.

    Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

    All measures are in the sample pbix file.

     

     

    https://www.dropbox.com/s/taqnf4wry1efvfk/daro.pbix?dl=0 

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Daro68 

Thank you for your message, and it will be helpful for me to look into your sample data to come up with more accurate measures.

Please share your sample file later if it is OK with you.

Thanks.

Daro68's avatar
Daro68
Icon for Advocate I rankAdvocate I
5 years ago

Dear Kim,

As I would not give up, I finally got it working in the most simplest way I imagined...  I just added a new column (Turnover cumulated) to the customer table and from there on I created 5 different treshold measures (Distinctcount, filtered by treshold) and that's all I needed to do.  The answer is sometimes so simple. 

Anyway, I wish to thank you for your kindness and support and as I said before, you thought me about Crossjoin. 

 

This is what I needed to obtain for this limited customer discount groups.

 

Have a nice day.

David