Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a measure that is meant to display the order quantity of the PRIOR year.
So if there is a filter on the page for "Year = 2024", this measure should display the quantity for 2023.
In the original model, the below measure works perfectly. We are creating a new model (due to move from on-prem to cloud datasource). The new model tables and relationships are set up identically to the original.
However, this measure is coming up blank in the new model. It will not populate results -it seems to not be respecting the "ALL('Calendar'[Year])"
Can anyone please help me understand why this would no longer work?
Hi @PBIUser23 - slight change as per shared measure . check the below
Order Qty - PY =
VAR selPriorYear = SELECTEDVALUE('Calendar'[Year])-1
RETURN
CALCULATE(
SUM(Orders[Total Order Qty]),
FILTER(
ALL('Calendar'),
'Calendar'[Year] = selPriorYear
)
)
or try with sameperiodlastyear too.
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.