Microsoft Power BI Cookbook

Scenario specific measures

It may be necessary to create scenario-specific measures such that multiple scenarios can be visualized concurrently

Internet Sales Plan 20% Above Plan = VAR FilterContext = [Sales Plan Scenario Filter Branch]VAR ScenarioValue = [Internet Sales Plan Amount]*CALCULATE(MIN('Plan Scenarios'[Var to Plan]),FILTER(ALL('Plan Scenarios'),'Plan Scenarios'[Plan Scenario] = "20% Above Plan"))VAR PlanScenario = "20% Above Plan"RETURN SWITCH(TRUE(), FilterContext = "No Selection",ScenarioValue,CONTAINS(VALUES('Plan Scenarios'[Plan Scenario]),'Plan Scenarios'[Plan Scenario], PlanScenario), ScenarioValue,BLANK())

This measure defaults to its scenario (20% Above Plan) if no scenario filter has been applied and, more importantly, ...