Calculate a percentage on total from same table with different filter
I'm trying to do something in PowerBI and I'm not sure if it is even possible or whether this is the appropriate place or tool? Basically, I'm up to my neck in calculations and numbers have lost all meaning ... PLEASE HELP!
I have a table (below) that is displayed twice with different visual level filters on the field Account. The top one is development items (DEV) and the lower is the total overhead (OV) against all development activity. I have the total number of hours from timesheet data and have the SUM (Hours (rounded)) and the %GT Hours Rounded. I now want to multiply %GT Hours Rounded by the total Hours for the overheads. i.e. for UC-7046 (top row) this would be 0.02% * 405.45
Does this make sense? Can I do it? Should I do it? Is there a better way to do it?