SelectedValue function not working correctly within a calculate(sum) ?

[Zarlot531]

Check this out. I have sales data going back to 2018 in this dataset. The "YearMinus" shows that the 

Date(selectedvalue('Query1'[year])-1,1,1)

 produces 1/1/2021 when clicked on 2022 year. 

yet, the measure brings back the same exact number as the slicer, despite me wanting everything from 1/1/2021 based on 2022 being selected. Oh wait... the measure isn't able to overcome the slicer is it. The slicer is keeping this within 2022. I need a separate year table that's indepdenent. I think i figured this out actually. I'll still post it in case it helps anyone else. 

[Greg_Deckler · Accepted solution]

@Zarlot531 Not sure you need a separate table, you could use ALL or ALLEXCEPT to override the slicer filter context and then filter down to the dates you want.