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
Hi charles_o,
Is this your solution?
Scenario =
VAR allLikelyhood =
CALCULATE (
CONCATENATEX ( VALUES ( Table1[Likelyhood] ), [Likelyhood], "," ),
ALLEXCEPT ( Table1, Table1[Project] )
)
RETURN
IF (
allLikelyhood = "Certain",
"Low",
IF (
allLikelyhood = "Certain,Expected",
"Base",
IF ( allLikelyhood = "Certain,Expected,Likely,Hopeful", "High", "ERROR" )
)
)
Best Regards,
Dale
EDIT: Got to what I wanted with this- One last ask below!
Scenario =
IF (
Table1[Likelyhood] = "Certain",
"Low,Base,High",
IF (
Table1[Likelyhood] = "Expected",
"Base,High",
IF ( Table1[Likelyhood] = "Likely", "High",IF (Table1[Likelyhood] = "Hopeful", "High")
)
)
)
Looks like this:
I want to use a slicer on my dashboard to display the data by "Low", "Base", or "High". Currently my options are "Low,base,High", "Base,High", "high".
Any Suggestions?
Hi PBI friends, charles_o, v-jiascu-msft
it's was not easy question but i suggest another workaround solution. Possible is can be useful.
Here is the LINK to example code.
And here is example itself:
If you have a questions ask back.
Best regs
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
Fantatic!
Thanks v-jiascu-msft
I change a little "Scenario" column:
Scenario = IF(SEARCH("likely";[Likelyhood];1;0)>0 || SEARCH("hopeful";[Likelyhood];1;0)>0 ;"High"; IF(SEARCH("expected";[Likelyhood];1;0)>0;"Base"; IF(SEARCH("certain";[Likelyhood];1;0)>0;"Low"; "Error" )//high )//base )//lowAnd THIS is a cAsE independent solution.
Best regs
