Make filter to filter in a specific table only?

[Anonymous]

I have a ClientType dimension connected to Date dim. (The ClientType has columns: ClientNo, Year and Type)

In the pbix  I use a filter on Date dim, on year, which correctly filters my fact in the visualizations… It also correctly filters the dimension for the selected year.

My issue is; that I want to use the same dimension value for both current year and LY measures:

Revenue YTD := CALCULATE([Revenue] , DATESYTD('Date'[Date] ,"31/05" ))

Revenue LYTD:=CALCULATE( [Revenue YTD],  SAMEPERIODLASTYEAR('Date'[Date]))

(This second measures: fetchs data for last year, and is also trying to pick the dimension from last year (which I dont want!!)… And I get the strange behavior where I can see the data but not in the dimension only in the total…)

[AllisonKennedy]

@Anonymous Have you marked your date table as a date table? https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html 

I prefer DATEADD to SAMEPERIODLASTYEAR, but both should work if you have the date table marked correctly...