Forum Discussion

charles_o's avatar
charles_o
Helper I
8 years ago
Solved

Scenario Help

Hi- I have data that is organized by project in rows with a column of expectations of likelyhood.   Certain Expected Likely Hopeful   I need to then be able to sort this data into 3 scenarios-...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

    LowLow
    BaseBase
    HighHigh
    LowLow,Base
    BaseLow,Base
    LowLow,High
    HighLow,High
    BaseBase,High
    HighBase,High
    LowLow,Base,High
    BaseLow,Base,High
    High

    Low,Base,High

    3. Create relationships and change the filter direction to Both.

    Scenario_Help2

     

    Best Regards,

    Dale

charles_o's avatar
charles_o
Helper I
8 years ago

I think we are misunderstanding this a bit.

 

  Included in
ACERTAINHigh, Base, Low
BEXPECTEDHigh, Base
CLIKELY High
DHOPEFULHigh

 

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.

McCow's avatar
McCow
Resolver III
8 years ago

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? Do you can specify pls?

  • charles_o's avatar
    charles_o
    Helper I
    8 years ago

    This is the set up for my data. Currently I have graphs, I am using the "slicer" in table3. When I toggle to "Low" on the slicer, it still shows all the data. However, looking at Table3, we can see that "Low" is only related to "Low,Base,High".

     

     Does not make sense, since I do not see how that should bring up my other scenarios.


    Relationship

    Table 3Table 1- Main TableTable 2- Middle Table

    • McCow's avatar
      McCow
      Resolver III
      8 years ago

      Oh, charles_o

      I see now how you trouble is.
      The all relationships in this case must be activated for "Both" directions not "Single".

       

      Just make changes, as v-jiascu-msft already described. Look here:

       

      I hope its solved your problem.

       

      Best regs

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi charles_o,

       

      Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

       

      Best Regards!
      Dale

      • charles_o's avatar
        charles_o
        Helper I
        8 years ago

         

        Got it to work! Sorry this took forever!