 # DAX : Incorrect Total

DAX Incorrect Total.xlsx (11.5 KB)

Hi all

Trying to get the correct total in a Matrix Visual.

I have uploaded an excel file. Simplifying the problem.

Can you pls post your pbix file. I think the solution is fairly straight forward. Check if the total is filtered and then use the appropriate measure, either countrows or distinctcount.

Hi thank you for responding so promptly.
I will send you the file in the next one hour.
Regards

DAX Incorrect Total.pbix (29.3 KB)

Hi there,

Thank you

Hi There,

I solved the problem

Correct DAX = SUMX(
VALUES(TABLE[Purpose]), DISTINCTCOUNT(TABLE[Participant ID)

Thank you

Continuing the discussion from DAX : Incorrect Total:

Hi @rm.goha[quote=“rm.gohain, post:1, topic:7160, full:true”]
DAX Incorrect Total.xlsx (11.5 KB)

Hi all

Trying to get the correct total in a Matrix Visual.

I have uploaded an excel file. Simplifying the problem.

[/quote]

in

This text will be hiddenWe can resolve it using Summarize.Please find the attached Pbix.
Distinct particpants.pbix (36.1 KB)

Count1 = CALCULATE(SUMX(SUMMARIZE(‘Table’,‘Table’[Purpose ],“A”,DISTINCTCOUNT(‘Table’[Participant ID])),MAX([A])))

Regards,
Sandy 2020-05-17T05:00:00Z

@rm.gohain