Forum Discussion

tasmiaa's avatar
tasmiaa
Icon for Advocate I rankAdvocate I
6 years ago

Measure showing previous scenario

Account Value Scenario A 10 A1 A 5 A2 B 3 A1 A 5 A3 A 4 A1 I have a slicer that allows users to pick their Scenario (A1, A2, A3) and a measure that sums Value at the giv...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

tasmiaa sorry it is not clear what is the logic to get previous scenario. Can you provide more details?

tasmiaa's avatar
tasmiaa
Icon for Advocate I rankAdvocate I
6 years ago

Sure!

 

Previous Scenario = IF(SelectedValue(Scenario) == "A1", "A3", IF(SelectedValue(Scenario) == "A2", "A1", If(SelectedValue(Scenario) == "A3", "A2")))

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    tasmiaa here is the measure for previous scenario value

     

    Previous Scenario = 
VAR __selectedValue = SELECTEDVALUE ( PRev[Type] ) 
VAR __prev = SWITCH ( __selectedValue, "A1", "A3", "A2", "A1", "A3", "A2" )
RETURN
CALCULATE ( [Total Amt], PRev[Type] = __prev )

     

    change table and col name as per your mode, [Total Amt] is simple sum of amount column