DAX to calculate "Additional Funnel needed"

[KRISH80]

Hi All,

I am at a situation where i need to calculate "What is the additional Gross Profit needed to reach gross profit of 16%". 16% is the organizational target for this year. Below is an example :

I have a sales table which has my Contract Value, Gross Profit and Gross Profit Margin details. I have a deal with customer X, with 1Mn of contract Value but my Gross Profit is 10K which means by Gross Profit Margin is at 10%. But now i need to find out what is that additional Grossprofit needed to need margin of 16%.

Calcuation : Gross Profit / Contract Value = Margin %

Kindly help. Let me know if you need more clarity.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Perhaps this:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Gross-Margin-Revenue-and-Cost-GMRC/m-p/58443...

[KRISH80]

@Greg_Deckler  can you kindly help me with your email and i can can send you a sample excel file with dummy data