Forum Discussion
Anonymous
7 years agoNot applicable
Tricky Switch Function using selection slicers
Hi Experts See Attached file link on one drive i am trying to write a swicth function - see folder PL Hyperion Summary - Measure "Test". Which give the net sale value based on the selection cri...
- 7 years ago
Hi Anonymous,
Try to simplify and make the measure below.
Test = VAR Timeframe = SELECTEDVALUE ( Periods[Period] ) VAR Selction = SELECTEDVALUE ( Activity[Scenario] ) VAR AOP = SWITCH ( Timeframe; "MTD"; [AOP Total Management]; "QTD"; [AOP QTD Total Management]; "YTD"; [AOP YTD Total Management]; [AOP Total Management] ) VAR PY = SWITCH ( Timeframe; "MTD"; [PY Total Management]; "QTD"; [PY QTD Total Management]; "YTD"; [PY YTD Total Management]; [PY QTD Total Management] ) RETURN SWITCH ( Selction; "AOP"; AOP; "PY"; PY; BLANK () )I'm making one variable for AOP another for PY this will had the possbility to have line 16 in the formula, on the last line I'm returning to the variables to get the result.
Please check if you have the expected result for all alternatives.
Regards,
MFelix
MFelix
7 years agoSuper User
Hi Anonymous,
You have added a parameter in the switch function that is not making the comparision then it breaks out the rest of the function and you are make the Measure as the Values you want to compare and the comparision as the result.
Check the line 16 on your measure that should not be there.
Regards,
MFelix
Anonymous
7 years agoNot applicable
Just removed link 16...not getting the desired results...HELP..