Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
5 years ago
Solved

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 tha...
Need Help
  • vanessafvg's avatar
    vanessafvg
    5 years ago

    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

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

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
 
  • Justas4478's avatar
    Justas4478
    Post Prodigy
    5 years ago

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