topic Re: Dyanmic Sales measure related to selected value from slicer in DAX Commands and Tips

Dyanmic Sales measure related to selected value from slicer

King8James — Wed, 10 Aug 2022 13:33:14 GMT

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

Re: Dyanmic Sales measure related to selected value from slicer

Anonymous — Tue, 16 Aug 2022 07:33:18 GMT

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.com)

Regards,

Xiaoxin Sheng

Re: Dyanmic Sales measure related to selected value from slicer

King8James — Tue, 16 Aug 2022 16:20:34 GMT

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.