We will build the measures in sequence.

1. A Total Sales Measure...

Visualise...

We cannot create a scenario model using [Total Sales] because the Sales[Unit Price] cannot be isolated from the Sales[Order Quantity].

2. Alternative Total Sales Measure (Total Sales based on Quantity and Unit Price)...

Visualise...

3. Create a Pricing Scenario Measure...

Home > Data Tab > New Measure...
...Pricing Scenario = IF(HASONEVALUE(Percent Price Change[Price Change]), VALUES(Percent Price Change[Price Change]), 0)

Visualise...

4. Create a Scenario Sales Measure...

Home > Data Tab > New Measure...
...Scenario Sales = SUMX(Sales, (Sales[Unit Price] * (1 + [Pricing Scenario])) * Sales[Order Quantity])

Visualise...

Review how the New Measures respond to Slicing.

Visualise...

Selecting Products in the Chart shifts the context of the Table, [Scenario Sales] shows only the figures for the selected Products.

5. Create a All Products Sales Measure (to show Total Sales for all Products under the scenario conditions)...

Visualise...

6. Create a Selected Products Sales Measure (to show Total Sales for all selected Products under the scenario conditions)...

Visualise...

7. Create a Selected Scenario Sales Measure (to show Total Sales for under the scenario conditions)...

Visualise...

8. Create Additional Summary Measures (to show the overall impact of scenario conditions)...

Home > Data Tab > New Measure...
...Actual vs. Scenario = [Selected Scenario Sales] - [All Sales]
...Percentage Change in Scenario = DIVIDE([Actual vs. Scenario], [All Sales], 0)

Visualise...

Review to appreciate the relative capabilities of each measure.

ABI