Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Everyone,
Can someone please help how to achieve the following?
I am trying to compare two planning/scheduling scenarios side by side to see which scenario is better. I have a filter from which I can select multiple/two scenarios.
Thanks in advance!!!
Solved! Go to Solution.
Hi @HabibAdil ,
Due to I don't know your data model, here I will show you two workarounds to achieve your goal.
1. If your calculation logic could be producting Constants from Fact table with Constants from Scenario table, you can try this way.
Measure =
VAR _CONSTANT1 = CALCULATE(SUM(Scenario[Value]),FILTER(Scenario,Scenario[Scenario] = MIN(Scenario[Scenario])))
VAR _CONSTANT2 = CALCULATE(SUM(Sample1[Constants]))
RETURN
_CONSTANT1 * _CONSTANT2
Measure2 =
VAR _CONSTANT1 = CALCULATE(SUM(Scenario[Value]),FILTER(Scenario,Scenario[Scenario] = MAX(Scenario[Scenario])))
VAR _CONSTANT2 = CALCULATE(SUM(Sample1[Constants]))
RETURN
_CONSTANT1 * _CONSTANT2
Result is as below.
2. You can create a Fact table with all data from each Scenario.
Measure 2 = CALCULATE(SUM(Sample2[Value]),FILTER(Sample2,Sample2[Scenario] = MIN(Scenario[Scenario])))
Measure 3 = CALCULATE(SUM(Sample2[Value]),FILTER(Sample2,Sample2[Scenario] = MAX(Scenario[Scenario])))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @HabibAdil ,
Due to I don't know your data model, here I will show you two workarounds to achieve your goal.
1. If your calculation logic could be producting Constants from Fact table with Constants from Scenario table, you can try this way.
Measure =
VAR _CONSTANT1 = CALCULATE(SUM(Scenario[Value]),FILTER(Scenario,Scenario[Scenario] = MIN(Scenario[Scenario])))
VAR _CONSTANT2 = CALCULATE(SUM(Sample1[Constants]))
RETURN
_CONSTANT1 * _CONSTANT2
Measure2 =
VAR _CONSTANT1 = CALCULATE(SUM(Scenario[Value]),FILTER(Scenario,Scenario[Scenario] = MAX(Scenario[Scenario])))
VAR _CONSTANT2 = CALCULATE(SUM(Sample1[Constants]))
RETURN
_CONSTANT1 * _CONSTANT2
Result is as below.
2. You can create a Fact table with all data from each Scenario.
Measure 2 = CALCULATE(SUM(Sample2[Value]),FILTER(Sample2,Sample2[Scenario] = MIN(Scenario[Scenario])))
Measure 3 = CALCULATE(SUM(Sample2[Value]),FILTER(Sample2,Sample2[Scenario] = MAX(Scenario[Scenario])))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much, the 2nd suggestion worked!!!!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
68 | |
64 | |
52 | |
39 | |
26 |
User | Count |
---|---|
80 | |
57 | |
45 | |
44 | |
35 |