cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

## Incorrect Total of measure column

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

2 ACCEPTED SOLUTIONS
Super User

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Community Support

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.

2 REPLIES 2
Community Support

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.

Super User

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors