Forum Discussion
Syndicate_Admin
3 years agoAdministrator
Column count
Good afternoon First of all, I thank you for your attention. I've been trying to find a solution for a very simple calculation to do with pivot tables, but I can't solve it in PBI. In t...
- 3 years ago
Please try the following measure:
Count of Distinct Categories per Customer = SUMX( Values(Table[Customer]), CALCULATE( DISTINCTCOUNT(Table[Category]) ) )Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Anonymous
3 years agoNot applicable
Hi Syndicate_Admin ,
The issue with this post has been solved, if there are other questions please publish a new post, there will be professional engineers, super users and forum users to help answer.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.