Matrix Subtotals Different calculation....

Question

I know there are a variety of posts on this but I couldn't seem to find one that had the solution that I was looking for... I'm hoping one of your wonderful minds can help me out.&nbsp;&nbsp;Here is a little context. I do work for a couple of Oil and Gas companies and am trying to build out a dynamic netback tool (Netback is essentially the same as calculating the Cost of goods). So there are a variety of costs that go into getting a barrel of oil out of the ground, some fixed and some allocated. As I am in the development stage I am treating everything as a fixed cost and can later break it out. A majority of the costs are not allocated to a well but to the entire field. With the current pandemic and oil prices, this company is trying to determine what wells are economic and what are not. The purpose of this tool is to run scenarios where you shut-in (turn off) a well, thus no more oil (which means cashflow) is coming from that asset, but since there are a large number of fixed costs they need to get reallocated to the other wells. I have managed to get this tool to what feels like 90% of the way but now I'm stuck.&nbsp;&nbsp;I have a disconnected table with each well listed out which is used as a slicer. When a well is selected it sets the production to 0 and recalculates the total oil. From that, I get a ratio that I can multiply my costs by so that you can get costs down to a well level.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;As you can see you can select a well and it will set the production to 0 and the ratios (%) will change accordingly. Now what I need to do is get everything to sum up correctly.&nbsp;&nbsp;The picture above helps to illustrate what is happening.The item boxed pink is divided by the item boxed in purple to get the Dynamic TF RatioThe Static Hierarchy amount (highlighted yellow) is multiplied by the ratio to get the green highlighted itemEverything is working correctly so far now this is were I am struggling...I need the blue box to sum the red box instead of following the same operation as what I listed.Does anyone have any suggestions on how to accomplish this?&nbsp;&nbsp;Thank you in advance!!

greg_deckler · Accepted Answer

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Forum Discussion

Related content

Customize subtotal in matrix

Different Calculations

Calculating row subtotals differently

Calculate subtotal using dax

Different calculations for Row Subtotal and for Column Subtotal