Forum Discussion
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?
The margin formula is this, and in the row it is calculated correctly
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
4 Replies
Can you please share the sample data and let us know about the desired output in the Total Column
Can you please share the sample data and let us know about the desired output in the Total Column
This is the formula:
Margine = ((SUM(MOVIMAG[VALVEN1])-[QTVEN] * SUM('TABRILIS'[PREZZO]))/([QTVEN] * SUM('TABRILIS'[PREZZO])))*100
and this is the correct risult: 61,625 (63,93+57,32=121.25/2=61,625) media
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
