Total no cumulative

[Cervo114]

Hi, 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

[Anonymous · Accepted solution]

Hi @Cervo114 ,

Do you mean that you want to calculate average based on above each row percentages instead of total percentage in subtotal field?

I  think you can calculate the average based on percentage measure above.

My Sample:

Measure = DIVIDE(SUM('Table'[Value1]),SUM('Table'[Value2]))

Create a new measure to calculate average based on percentage above.

Measure 2 = AVERAGEX(VALUES('Table'[Category]),[Measure])

Result is as below.

Best Regards,
Rico Zhou

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