calculate last year value

[YASHASHRI]

I calculated last year's sales value but it is giving me an empty value.

the scenario is: I have a table with region max year sale value (for the current year) and yoy (max year-last year).
for example, if i am selecting 2023 and quarter Q2, then the value is 25 and after that selecting 2022 and quarter Q2, then the value is 51. 
so for the year 2023 yoy value should be 25-51=-26 
but I am getting a value as 25 because last year's value is 0. 


how to calculate LY value in such a way that it will give result on yearly level as well as quarterly level.

[YASHASHRI]

@eliasayyy 
I removed all the filters related to date from the dax query.now it is working. But i have a slicer of YY-QQ so whenever i select anything the same issue occurs but  then insted of that when i use year and quarter slicer seperately it works well. What can be the reason?

[eliasayyy]

did you use the all function ? the all will dirgeard all filters pelase share more details what measure did you use

[YASHASHRI]

yes before i was using all(date(year)). Now i removed the all condition 

[eliasayyy]

te all(date(year)) wil lremove all filters so maybe use the allexcept(date,date[year]) ths will keep the filetrs on for year but please share more info so i can help you more

[eliasayyy]

ok plese share sample of your data and your results

[eliasayyy]

if you have filters on make sure that in your measure , you let powerbi know that dont look at filters maybe use removefilters