Forum Discussion
Scenario Help
Hi charles_o,
You can try the approach of McCow. Another method.
1. Create a middle table for all the scenario.
Scenario
Low Base High Low,Base Low,High Base,High Low,Base,High 2. Create a table for slicer.
SlicerScenario
Low Low Base Base High High Low Low,Base Base Low,Base Low Low,High High Low,High Base Base,High High Base,High Low Low,Base,High Base Low,Base,High High Low,Base,High
3. Create relationships and change the filter direction to Both.
Best Regards,
Dale
I think we are misunderstanding this a bit.
| Included in | ||
| A | CERTAIN | High, Base, Low |
| B | EXPECTED | High, Base |
| C | LIKELY | High |
| D | HOPEFUL | High |
Think about it like this
Low = A
Base = A + B
High = A + B+ C + D
So when I select "High", the data for Low and Base must also be included.
Yes, charles_o, right!
charles_o wrote:......
So when I select "High", the data for Low and Base must also be included.
And I don't see the collision. Our last solution is completely adjustable. All possible combinations must be in the table "Solution" described. I personally include this solution in my personally DAX-gems (thank v-jiascu-msft). Or somewhere exist some trouble? Specify pls