Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to 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.
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 @Anonymous, the solution that you proposed it did actually solve the problem.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
8 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |