Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 @v-rzhou-msft, the solution that you proposed it did actually solve the problem.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!