Hello,

I have a table in Power BI that aggregates rows as sum, including the column total.

The rows need to remain aggregated as sum, but the column total needs to be aggregated as average.

Is there a way to do this in Power BI?

Please see attached example. 

Many thanks.