I show below my current DAX formula which does give my the result i require

I do however wish to calculate Gross Profit , Gross Profit Margin And Net Profit

I have tried several attempts , and also created an "interdependent problem

`Total 000's = VAR Revenue = CALCULATE(SUM('Mateen Combined'[Value]), FILTER('COA Category','COA Category'[MainCat] = "Revenue" )) VAR COGS = CALCULATE(SUM('Mateen Combined'[Value]), FILTER('COA Category','COA Category'[MainCat] = "COGS" )) * -1 VAR OPEX = CALCULATE(SUM('Mateen Combined'[Value]), FILTER('COA Category','COA Category'[MainCat] = "OPEX" )) * -1 VAR Finance = CALCULATE(SUM('Mateen Combined'[Value]), FILTER('COA Category','COA Category'[MainCat] = "Finance" )) * -1 VAR DEPN = CALCULATE(SUM('Mateen Combined'[Value]), FILTER('COA Category','COA Category'[MainCat] = "DEPN" )) * -1 VAR NT = CALCULATE(SUM('Mateen Combined'[Value]), FILTER('COA Category','COA Category'[MainCat] = "NT" )) * -1 RETURN DIVIDE(Revenue +COGS+OPEX+Finance+DEPN+NT,1000,0 )`