Last Year calculation from measures that contains filter

[John33]

Dear BI experts, 

I'm stucked in a situation for 2 days and after a lot of research I couldn`t solve my issue. (My apologize if there is an easy solution for that)

I created a measure which result is the sum of moves from a filtered table with 2 criterias set by "OR" function, it's working well. 

 I also set a "Last Year" measure  in order to stablish a comparison, however when I insert a date slicer and define 2019 period, It's not bringing 2018 values. Is there anyway to have the slicer only applying to the first measure?

I also tried using  CALCULATETABLE , but it's not working, it seems to be a filter date problem.

Volume Moves for Domestic Full = SUMX(FILTER('CAMS';OR('CAMS'[Product Move Class.Move Type & Category]="LoadLaden";'CAMS'[Product Move Class.Move Type & Category]="DischargeLaden"));[SUMMOVES])


LY Volume Domestic Full = CALCULATE([Volume Moves for Domestic Full];DATEADD('Calendar'[Date].[Date];-1;YEAR))

Thank you 🙂

[jdbuchanan71 · Accepted solution]

Hello @John33 

Can you try removing the second .[date] from you PY measure?  So it would be.

LY Volume Domestic Full = CALCULATE([Volume Moves for Domestic Full];DATEADD('Calendar'[Date];-1;YEAR))