How to do SUM on Distinct Count

[Maz_0102]

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 

[amitchandak]

@Maz_0102 , Try a measure like

Sumx(Values(TBT[Reporting Person]), calculate(Distinctcount(Table[Name]) ) )

[Maz_0102]

@amitchandak 

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