Forum Discussion
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.
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.
4 Replies
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicIf 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]))
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.
I tried the measure used in the video and it solved the problem. Results look good so far. Thank you.
