Incorrect value if interaction with filter (Date Slicer) is on

[HamzaKG]

here we can see the first table that has interaction with filters on top has wrong values but the second one when i turn the interactions off has right values.

Here is my measure to calculate last year value

` Last_Year_value = CALCULATE(
    SUM(Profit_and_Loss[Value]),
    DATEADD('Calendar'[Date],-12,MONTH)
    )`

I have a relation one sided between profit_and_loss table and Calendare table

here it is the relation between the two tables

I tried using "REMOVEFILTERS() / ALL() / ALLEXCEPT()", but non of them worked.

[v-rzhou-msft · Accepted solution]

Hi @HamzaKG ,

I suggest you to create a measure by below code. Please make sure there is a [Year] column in your Calendar table.

Last_Year_value = 
CALCULATE (
    SUM ( Profit_and_Loss[Sales] ),
    FILTER ( ALL ( 'Calendar' ), 'Calendar'[Year] = MAX ( 'Calendar'[Year] ) - 1 )
)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HamzaKG]

Thank  you so much @v-rzhou-msft, the solution that you proposed it did actually solve the problem.