Incorrect Total of measure column

[Laura7]

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?

[Jihwan_Kim · Accepted solution]

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] )
)

[v-tianyich-msft · Accepted solution]

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.

[Jihwan_Kim · Accepted solution]

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] )
)