topic Incorrect value if interaction with filter (Date Slicer) is on in DAX Commands and Tips

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

HamzaKG — Fri, 04 Aug 2023 12:14:10 GMT

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.

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

Anonymous — Mon, 07 Aug 2023 08:20:10 GMT

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.

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

HamzaKG — Mon, 07 Aug 2023 11:55:41 GMT

Thank you so much Anonymous, the solution that you proposed it did actually solve the problem.