Forum Discussion
Sum Distinct Count
Hi, this is my first post and I am very much new to the PowerBI world. I am reviewing the assignment of training items. Each training item is a document. Each document is assigned to a user ...
You can also take Anonymous 's solution, and turn it into a single measure, without the need to create any extra calculated columns or tables:
Sum of Uniques = SUMX( VALUES(Table1[User]), CALCULATE( DISTINCTCOUNT(Table1[Item ID]) ) )It's the same answer and method, just condensed into one expression.
You can also take Anonymous 's solution, and turn it into a single measure, without the need to create any extra calculated columns or tables:
Sum of Uniques =
SUMX(
VALUES(Table1[User]),
CALCULATE( DISTINCTCOUNT(Table1[Item ID]) )
)It's the same answer and method, just condensed into one expression.
That worked!!!
I cannot tell you how useful it is for me, it actually saves hours and hours of work.
THANK YOU