Forum Discussion
Solved
Slicer Selected Value Not Working in Calculated Column Logic
Hello, I am having what I think is a context issue. I am basically trying to use the year from a datetime dimension table in a slicer and use the selected year to filter data in another table. I c...
This following appears to be working:
Jan DCC Budget as Measure =
CALCULATE(SUM(Directs[Cost]),
FILTER(Directs, Directs[Effective] <= DATE(Directs[_Year Selected], 1, 5) && Directs[Expiration] >= DATE(Directs[_Year Selected], 1, 5)))
parry2k, thank you for the quick response, but unfortunately your suggestion doesn't work.
Directs[Effective].[Date] and Directs[Expiration].[Date] are Directs columns, not measures, so they are not valid for use in a measure. These are both red underlined.
I will try and see if using CALCULATE will work.
Sorry I missed that, yes please sure calculate