Forum Discussion

meowster's avatar
meowster
Frequent Visitor
3 years ago
Solved

Lookup date value applied on filter not working

Hello,    I am trying to use a date value from lookup as a variable for a filter but it doesn't seem to work. My DAX formula is shown as below: Table = VAR SelectedSalesDate = LOOKUPVALUE( ...
  • johnt75's avatar
    johnt75
    3 years ago

    You can't use SELECTEDVALUE when creating a table. Calculated tables are only calculated during data load or refresh, so they don't pay any attention to slicers or filters. If you need something to react dynamically to filters or slicers you need to do it in a measure.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You can't use SELECTEDVALUE when creating a table. Calculated tables are only calculated during data load or refresh, so they don't pay any attention to slicers or filters. If you need something to react dynamically to filters or slicers you need to do it in a measure.

  • meowster's avatar
    meowster
    Frequent Visitor
    3 years ago

    Thank you johnt75 for this info. Didn't know about this. I've managed to find a workaround by summarizing the data into another table and then apply the filters from there.