Dyanmic Sales measure related to selected value from slicer

[King8James]

Hello,

I need a measure that gives the sales of selected scenario and adds preivous sales  i have created the folowing measure

New sales =

var forcast = SELECTEDVALUE(scenario[Alternative])

return

CALCULATE( sum(data[Sales]), FILTER(data, data[Alternative]= "FIX" && data[Alternative]= "Forecast")

the issue i have is the overlap in month may june and july (it can change depending on the chosen scenario) how can i filter the duplicate value from fix so that i have all values from var 1 or var 2 (selected scenario) and the values that dosent exist from FIX like that 

here the data source

[Anonymous]

Hi @King8James,

You can use switch and selectedvalue function to redirect to different calculation expressions based on current selected value.

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup...

Regards,

Xiaoxin Sheng

[King8James]

hey thanks for you reply,

the issue i have is : i have to include the whole sales of the selected scenario for example if i choose var 1 sales start from may till january 2023 and fix should be the months before may (if  i choose var2  sales start from june 2022 till january 2023 and fix should be the months before june ) so the values of fix are  variable and depend on the chosen scenario.