topic Totalling a distinct count measure in DAX Commands and Tips

Totalling a distinct count measure

et123 — Wed, 11 Dec 2024 07:59:57 GMT

User Count = DISTINCTCOUNT('View Data'[DisplayName])

If I am using his meansure in a matrix I need the total to be a total of the distinct counts. I had seen a suggesion to use HASONEFILTER but not sure how to apply it to this measure to make it work correctly.

Re: Totalling a distinct count measure

timalbers — Wed, 11 Dec 2024 08:43:12 GMT

Hi et123

try something like this:

User Count = SUMX( VALUES( 'View Data'[DisplayName] ), DISTINCTCOUNT( 'View Data'[DisplayName] ) )

Re: Totalling a distinct count measure

mark_endicott — Thu, 12 Dec 2024 13:40:27 GMT

et123 - If I interpret your requirement correctly you need every row to show the same total, e.g. each row will show the total of the DISTINCTCOUNT('View Data'[DisplayName]), in which case this should work:

CALCULATE DISTINCTCOUNT( 'View Data'[DisplayName] ), REMOVEFILTERS( 'View Data' ) )

If this works, please accept as the solution, it helps with visibility for others with the same challenge, if it does not, please provide more information about what you are trying to acheive, and some sample data.

Re: Totalling a distinct count measure

Anonymous — Wed, 18 Dec 2024 03:05:59 GMT

Hi et123 ,

similar situation

Measure = DISTINCTCOUNT('Table'[Column])

Measure 2 = VAR _table = SUMMARIZE('Table',[Type],"Result",[Measure]) RETURN SUMX(_table,[Result])

Best Regards

Re: Totalling a distinct count measure

mark_endicott — Mon, 23 Dec 2024 10:46:24 GMT

et123 - did we resolve your issue? If we did, please select the appropriate solution, it helps with visibility for others and for SuperUsers to keep their status! Thanks!