Forum Discussion

Cervo114's avatar
Cervo114
Frequent Visitor
4 years ago
Solved

Total no cumulative

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 calcu...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.