Forum Discussion
How to do SUM on Distinct Count
Hi
I am using the matrix visualization below
for ROWS i am using a list of names from a table
and Colmns, im using a list of months from another table
then my value field is from the source tabkle called 'TBT' and doing distinct count on column called 'Name'
how do i get the column subtotals to reflect what's going across
eg first entry has 1 against may and June so should total 2
2 Replies
Maz_0102 , Try a measure like
Sumx(Values(TBT[Reporting Person]), calculate(Distinctcount(Table[Name]) ) )
hello Amit,
the formual didnt work...
The reporting person is from another table called members
the table has a relationship with the source data, because I am linking the names
appreciate your help as well, thank you
