Forum Discussion

Maz_0102's avatar
Maz_0102
Helper I
4 years ago

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 sou...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
4 years ago

Maz_0102 , Try a measure like

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

  • Maz_0102's avatar
    Maz_0102
    Helper I
    4 years ago

    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