Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Justas4478
Responsive Resident
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.

Calculation of total.PNG

1 ACCEPTED SOLUTION
vanessafvg
Super User
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.

https://www.youtube.com/watch?v=Rii_6qkLNh8





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!




View solution in original post

4 REPLIES 4
vanessafvg
Super User
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.

https://www.youtube.com/watch?v=Rii_6qkLNh8





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!




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

selimovd
Super User
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
 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.