Problem with the total

[Cervo114]

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

Margin = ((SUM(MOVIMAG[VALVEN1])-[QTVEN] * SUM('TABRILIS'[PREZZO]))/([QTVEN] * SUM('TABRILIS'[PREZZO])))*100

[v-luwang-msft · Accepted solution]

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 

https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M... 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[FarhanAhmed]

Can you please share the sample data and let us know about the desired output in the Total Column

[Cervo114]

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

[FarhanAhmed]

Can you please share the sample data and let us know about the desired output in the Total Column