Forum Discussion

curtismob's avatar
curtismob
Helper IV
8 years ago
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...
Need Help
  • curtismob's avatar
    curtismob
    8 years ago

    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)))

curtismob's avatar
curtismob
Helper IV
8 years ago

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's avatar
parry2k
Super User
8 years ago

Sweet, good for you. There you go!!