Forum Discussion
Solved
Problem with the total
Hi, I have a problem with the total, when there is a formula in the columns. Why in the total, does it calculate the formula as if it were a normal row, instead of giving me the total of the rows? T...
Hi Cervo114 ,
In this case, you need to create another measure, because when calculated directly, its sum is based on the full table calculation and not the direct sum of two values.
Margine 2 = sumx(table, [Margine ])And similar case refer:
https://community.powerbi.com/t5/Desktop/Total-is-wrong-in-a-matrix/m-p/348993
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Hi Cervo114 ,
In this case, you need to create another measure, because when calculated directly, its sum is based on the full table calculation and not the direct sum of two values.
Margine 2 = sumx(table, [Margine ])
And similar case refer:
https://community.powerbi.com/t5/Desktop/Total-is-wrong-in-a-matrix/m-p/348993
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien