Forum Discussion
Solved
Divide two columns in a table visual in Power BI
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!
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.
