This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I see in a .pbix the next filter page: IsCurrentFY is 1
And… I also have the next measure for Last Year: CALCULATE( xyz, SAMEPERIODLASTYEAR( 'Date'[Date] ) )
The visualization displays correctly; comparing xyz this year vs last year… I am wondering…
Why IsCurrentFY is 1 doesn’t take precedence? Is it that SAMEPERIODLASTYEAR overrides any filter?
@Anonymous , I not sure I clear with your question, but this calculation means
CALCULATE( xyz, SAMEPERIODLASTYEAR( 'Date'[Date] ) )
CALCULATE( xyz, filter(all('Date') , Date[Date] in <all last year date> ) )
refer
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
Yes, correct. My question is, what happens when you have a filter that wants to only display this year's data and a function like SAMEPERIODLASTYEAR explicitly trying to fetch last year's data...
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 24 | |
| 23 | |
| 17 | |
| 15 |
| User | Count |
|---|---|
| 63 | |
| 36 | |
| 29 | |
| 22 | |
| 22 |