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)))
I tried the following:
Jan DCC Budget as Measure =
CALCULATE(SUM(Directs[Cost]), Directs[Effective] <= DATE(Directs[_Year Selected], 1, 5), Directs[Expiration] >= DATE(Directs[_Year Selected], 1, 5))
The above with the follwoing error.
A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
