Sameperiod last year sales not working with slicers

[hnoori]

I have two new measures:

BrandQTD = TOTALQTD(sum(Query1[Brand Units]),Query1[Date])

and the same formula for last year

BrandQTD_LY = CALCULATE([BrandQTD],SAMEPERIODLASTYEAR(Query1[Date]))

They work fine but when I use a slicer, the sameperiodlastyear formula gives an error.

[Eric_Zhang]

---

@hnoori wrote:

I have two new measures:

BrandQTD = TOTALQTD(sum(Query1[Brand Units]),Query1[Date])

and the same formula for last year

BrandQTD_LY = CALCULATE([BrandQTD],SAMEPERIODLASTYEAR(Query1[Date]))

They work fine but when I use a slicer, the sameperiodlastyear formula gives an error.

---

@hnoori

What is in the slicer? Could you post the pbix file? You can upload the pbix file to OneDrive or any web drive and share the download link. Do note to mask sensitive data before uploading.

By the way, for those QTD,YTD functions, please use continuous dates by creating a calendar table and then create measures using the calendar table.

BrandQTD_LY = CALCULATE([BrandQTD],SAMEPERIODLASTYEAR(dimdate[Date]))

BrandQTD = TOTALQTD(sum(Query1[Brand Units]),dimdate[Date])