Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Stacked Product Count

Hi Everyone, I have been trying to figure this out but am getting nowhere. I have a dataset with customers and the products each customer is using. What I need is for get a count of what customer is...
Need Help
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    Measure can't make slicers, Column can. You can try the following methods.

     

    Count Product = CALCULATE(DISTINCTCOUNT('Table'[Product]),ALLEXCEPT('Table','Table'[Customer]))

     

    Measure:

     

    Count Client = CALCULATE(DISTINCTCOUNT('Table'[Customer]),ALLEXCEPT('Table','Table'[Count Product]))

     

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

After creating the measure, I was able to get the number of products each client is using!

 

Is there a way to add a slicer for this? If I click 2, it'll show me how many clients are using 2 products? If I click 4, it'll show me how many clients are using 4 products?

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

Measure can't make slicers, Column can. You can try the following methods.

 

Count Product = CALCULATE(DISTINCTCOUNT('Table'[Product]),ALLEXCEPT('Table','Table'[Customer]))

 

Measure:

 

Count Client = CALCULATE(DISTINCTCOUNT('Table'[Customer]),ALLEXCEPT('Table','Table'[Count Product]))

 

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.