Forum Discussion

HamzaKG's avatar
HamzaKG
Regular Visitor
3 years ago
Solved

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

 

@ Matrix Visualisation Error In Calculation
@Dax
@measure filter
@Power BI
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      HamzaKG
      Regular Visitor
      3 years ago

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