Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost 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
Icon for Most Valuable Professional rankMost 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