Column Total Data Grid Table Incorrectly Summing % field

[SachinC]

Hi,

I have a data grid table in PowerBI reporting on 5 columns, the 5th column being % values.

However, I do not want the % to be SUM but instead average.  

How do I get this done - i.e. columns 1-4 SUM and col 5 is Average?
Thanks!

[v-lionel-msft · Accepted solution]

Hi @SachinC ,

I think you are talking about this total value.

Try to do like this.

Measure = 
IF(
    HASONEFILTER(Sales[Brand]),
    MAX(Sales[Sale 2013]),
    AVERAGEX(
        Sales,
        Sales[Sale 2013]
    )
)

Best regards,
Lionel Chen

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

[amitchandak]

@SachinC , Percent value are Averages unless force to ve sum.

How are you doing it

Ideally, they should be like

Sum(A)/Sum(B)

Are you doing Sum(A/B)?

Or Average(A/B)