Forum Discussion

chq's avatar
chq
Icon for Helper II rankHelper II
7 years ago
Solved

Sum of Distinct Counts

I need to be able to total each of these distinct counts, not just see the number of distinct counts.  Essentially I want a total of each rows distinct count. Can that be done? I had to scrub the ...
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    7 years ago

    chq try following measure

     

    # Count = SUMX( VALUES( 'Table'[Event Title] )  ,CALCULATE(DISTINCTCOUNT( 'Table'[ID#] ) ))
chq's avatar
chq
Icon for Helper II rankHelper II
7 years ago

How would I be able to calculate the difference between the two years though? I need to be able to show percent change and the total count difference.