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 calculates the percentage between the columns. How could I do? Thanks in advance

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.

     

     

     

1 Reply

  • 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.