Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
  • MFelix's avatar
    MFelix
    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