Forum Discussion

Cervo114's avatar
Cervo114
Frequent Visitor
4 years ago
Solved

Total incorrect

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
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.