Calculate the difference between 2 measures with changing signs

[bchager6]

Hi All...

I'm stumped with this one. I created 2 What If parameters that I bake in to each measure below. In a clustered column chart I'd like to show the original Revenue as a column and then the Revenue net of any % changes in Price and Demand.

The challenge lies in the fact that the Price or Demand % changes can be either positive or negative. So while a +10% increase in price minus a 5% decrease in demand (10-5) is easy to calculate, I'm stumped on how to write something that could also handle changing signs, like a 10% decrease in price with a 5% increase in demand (-10+5). Im thinking that I may need to use variables.

Any thoughts?

Revenue after % Price Change =

SUMX('Item Sales','Item Sales'[Net Sales])

+ SUMX('Item Sales','Item Sales'[Qty] * ('Item Sales'[Price]

* '% Price Change'[% Price Change Value]/100))

Revenue after % Demand Change =

SUMX('Item Sales','Item Sales'[Net Sales])

+ SUMX('Item Sales','Item Sales'[Qty] * '% Demand Change'[% Demand Change Value]))

* 'Item Sales'[Price]/100)

[parry2k]

@bchager6 is this what you are looking for?

Qty = 50

Price = 5

Price Increate = 10%

Demand Decrease = 10%

New Demand = Qty - % Demand Decrease = 50 - 10% = 45 (new demand)

Price Increase = Price + 10% Price Increate = 5 + 5% = $5.25

New Value = 45 x $5.25 = 236.25 (original number is 50 x $5 = 250)

Is this correct understanding?

[bchager6]

Thank you for your reply. That's correct, and the solution also needs to handle the scenario where the price decreases and demand increases.

[parry2k · Accepted solution]

@bchager6 solution attached, you can tweak it as per your need. There are some other stuff, just ignore that.

[bchager6]

That's brilliant!

My Actual Value and Demand Value, when the Price Change and Demand Change parameters are both set to 0, are much higher than my baseline revenue value though (Qty * Price directly from the source data). I suspect that it has something to do with the Actual Price measure because when I change it from Actual Price = MAX ( 'My Table'[Price] ) to Actual Price = AVERAGE ( 'My Table'[Price] ) for example, both the Actual Value and Demand Value are almost equal to my baseline revenue value.

Any idea what's happening here?

[parry2k]

@bchager6 if possible share pbix file with explanation and I can take a look. 

[bchager6]

Thanks for your time here. Here is a link to the .pbix. I'm not able to attach files for some reason.

example.pbix 

[parry2k]

@bchager6 so I just looked at pbix, so changing MAX ( Price ) to Average (Price) works as expected, what challenge you see there, or what number is wrong, I'm not fully clear?

[bchager6]

I'm good actually. Thank you so much for your help!