Forum Discussion
Solved
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...
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.
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.