Forum Discussion
SelectedValue function not working correctly within a calculate(sum) ?
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.
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.
1 Reply
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.