Skip to main content
cancel
Showing results for 
Search instead 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

Reply
HamzaKG
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.

HamzaKG_0-1691151039510.png

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

HamzaKG_1-1691151083913.png

 

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

 

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
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.

View solution in original post

2 REPLIES 2
v-rzhou-msft
Community Support
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.

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.