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 

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

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

    Hello Kim,

     

    You understood me correctly.  Your idea of working with a non linked table (Turnover Group) looks pretty amazing.  Neither have I tried 'Crossjoin'.  Let me see if I can insert this in my project.  I'll definetely get back to you.

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

    Dear Kim, 

    I realized that with my solution I wasn't able to filter the years, so I retried your solution with a clear point of view and your solution is finally the better one. 

    I am really thankfull to you.  The crossfiltering did it... 😄

    Kudo's to you Kim !

     

     

    Kind regards,

    David

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

    Hello Kim,

     

    I've been trying till late in the evening to get your formula to work but unfortunately it didn't.  I have to admit we have a pretty complex data scheme.  Information is retreived from NAVISION SQL.  I will try to create a test file I can share.  

    • 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