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.

Responsive Resident

## Sum for total in table

I have a measure in the table and the total of that measure is boing done as calculation by the table. And it brings wrong total. But the other column totals are correct. Is it possible to change that total for that measure would be calculated as a SUM and not as a calculation.

1 ACCEPTED SOLUTION
Super User

you will not be able to change the total but what you need to do is understand why your total is wrong.   You need to underststand how dax and power bi works.

this video is useful in getting the nitty gritty on it.

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

4 REPLIES 4
Super User

you will not be able to change the total but what you need to do is understand why your total is wrong.   You need to underststand how dax and power bi works.

this video is useful in getting the nitty gritty on it.

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Responsive Resident

I tried the measure used in the video and it solved the problem. Results look good so far. Thank you.

Super User

Hey @Justas4478 ,

in DAX every calculation is done independently.

So the total is not the sum of the rows above, it's calculated also independent.

How does your measure look like? And where is the difference in the total? How does your data model look like?

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Responsive Resident

If I add all numbers together in the Exit Stock Forcast column the sum of them doesnt match the Total shown at the bottom of the table. That is the problem that I am trying to solve. The sum of them is higer than the number shown in the table total at the bottom. The other totals for other columns in the table are good. It is just that column that I dont know how to fix. This is the measure:

Exit Stock Forecast =
if([Stock On Hand] + [SKU Specific Open POs]- [Stock Forecast] <0,0, [Stock On Hand] + [SKU Specific Open POs]- ([SKU Specific Average Weekly Landed Cost] * [Weeks to Refresh]))

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors