topic Re: Incorrect Total of measure column in DAX Commands and Tips

Incorrect Total of measure column

Laura7 — Fri, 19 Apr 2024 08:15:35 GMT

Hello,

I have some problems with the sum of a measure column. This is my table:

As you can see here, Total of the Overview column is not added up correctly.
I calculate my Actuals column as follows:

Actuals = SUMX(FILTER('TabelleSales', 'TabelleSales'[Typ] = "A"), 'TabelleSales'[Sales])

The DP column like this:

DP = SUMX(FILTER('TabelleSales', 'TabelleSales'[Typ] = "DP"), 'TabelleSales'[Sales])

And the Overview column has this formula:

Overview = If([Actuals]<[DP],[DP],[Actuals])

Can someone please help me?

Re: Incorrect Total of measure column

Jihwan_Kim — Fri, 19 Apr 2024 09:46:07 GMT

Hi, I am not sure how your semantic model looks like, but please try something like below.

Overview fix = SUMX ( SUMMARIZE ( fact_table, product[product], calendar[Jahr], calendar[Month name], calendar[Month name order] ), IF ( [Actuals] < [DP], [DP], [Actuals] ) )

Re: Incorrect Total of measure column

Anonymous — Mon, 22 Apr 2024 06:46:12 GMT

Hi Laura7 ,

Thanks for Jihwan_Kim solution, if you want to use calculated columns, you can just change the DAX to calculated columns in the original DAX, you can check the result below:

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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