Total incorrect

[Cervo114]

I have a column that calculates the margin as a percentage, between some columns. In the total I would like you to average the margin between all the rows, instead also in the total row, it calculates the percentage between the columns. How could I do? Thanks in advance

[v-yanjiang-msft · Accepted solution]

Hi @Cervo114 ,

According to your description, I create a sample.

The average can't get the correct result in the Total.

Here's my solution, create a new measure.

Measure =
IF (
    ISINSCOPE ( 'Table'[Column1] ),
    [Average],
    SUMX ( VALUES ( 'Table'[Column1] ), [Average] )
)

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.