Divide two columns in a table visual in Power BI

[HanaB]

Hello everyone,

I have been struggling with a simple problem. Hopefully I can get help here.

My data is like this:

This is a table visual from the data. I want to have the average value on the Total row to be: 227/920=24.67%, instead of the average value highlighted here.

Thank you!

[HanaB]

It worked perfectly. Thank you 🙂

[HotChilli · Accepted solution]

I think it should work if you don't create the calculated column but create a measure instead and put that in the visual.

The DAX will be very close to the column DAX but using SUM as an aggregation on each field.