Precedence filter or SAMEPERIODLASTYEAR?

Question

I see in a .pbix&nbsp; the next filter page:&nbsp; &nbsp;IsCurrentFY is 1&nbsp;And… I also have the next measure for Last Year:&nbsp; &nbsp;CALCULATE( xyz, SAMEPERIODLASTYEAR( 'Date'[Date] ) )&nbsp;The visualization displays correctly; comparing xyz this year vs last year… I am wondering…&nbsp;Why&nbsp;&nbsp;IsCurrentFY is 1&nbsp;&nbsp;doesn’t take precedence? Is it that SAMEPERIODLASTYEAR overrides any filter?

amitchandak · Answer

Anonymous , I not sure I clear with your question, but this calculation means 
CALCULATE( xyz, SAMEPERIODLASTYEAR( 'Date'[Date] ) )
&nbsp;
CALCULATE( xyz, filter(all('Date') , Date[Date] in &lt;all last year date&gt; ) )
&nbsp;
refer
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/

anonymous · Answer

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

Forum Discussion

Precedence filter or SAMEPERIODLASTYEAR?

2 Replies

Related content

Filter precedence for PowerAutomate

Filter precedence in DAX functions

SAMEPERIODLASTYEAR with filter

SAMEPERIODLASTYEAR()

Issue with SAMEPERIODLASTYEAR and Manual Time Intelligence