DAX : Incorrect Total

DAX DAX Calculations
1

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.

Could someone help me, please?

2

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.

3

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

4

DAX Incorrect Total.pbix (29.3 KB)

Hi there,
Please find the pbix file

Thank you

5

Hi There,

I solved the problem

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

Thank you

6

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.

Could someone help me, please?
[/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

7

@rm.gohain

i checked your pbix file…

Total Instances of Support = COUNTROWS(Table1)
for total participants you can also use:
Total Participant = COUNTROWS(VALUES(Table1[Participant ID]))

good job and all the best.

8

Thanks to the contributors of this post. I hope that you are all having a great experience using the Support Forum so far. We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum.