Sum for Dax measure column not correct.

[rxiaoadvauto]

Hello all! I wrote a measure for mix by product class and the sum for this measure is not correct. Instead of -29, the result is 0 for the column. I wrote another measure called Test_Mix, where I used the SUMX function and put my table name and the Mix column I made as the arguments. However, I'm getting wrong numbers for this column. I verified that the numbers in the mix column is correct via a historical report: it's just the sum of the column is wrong.

[v-zhengdxu-msft · Accepted solution]

Hi @rxiaoadvauto 

Please try to use SUMMARIZE() function.

Create a virtual table with the help of the SUMMARIZE function.

The SUMMARIZE function returns a summary table for the requested totals over a set of groups.

Iterating through virtual tables allows you to make sure that the logic you implement is iterating through the correct context for the total versus any natural context that might occur via selections made on a report page.

Here are some links for your reference:

Fixing Incorrect Totals Using DAX Measures In Power BI | Master Data Skills + AI (enterprisedna.co)

Power BI: Totals Incorrect and how to Fix it - Finance BI (finance-bi.com)

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.