cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

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

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]),
)````

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.

1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Regular Visitor

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