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.