How to fix bug in dax function (from date - to date slicer)

[Anonymous]

hey everyone, 

I'm desperate to fix this problem below. I will share dax and screenshots as well. 
It's working for 2024,25,26,27 but it's not working 2022 and 2023... interestingly It's actually filtering the selected dates when I remove dimensions from "Rows" I have no idea how this is happening, and If it's easy I want to fix my dax code, if not other approaches will be appreciated.

this is the dax function I use in the matrix view, filtered by "1"

NUMBER #1
and this filters the records between selected dates, from date - to date, here below 
(bring from 2022 - Q2 to 2023 - Q2) but we don't have any dimensions in the Rows

NUMBER #2 
it works after 2023 but when it comes to 2022 and 2023 it's NOT working

when I remove "Rows" it's working

NUMBER #3 
It's not even working in 2022 (when remove "rows" its working)

[Anonymous · Accepted solution]

it was filterin on table view, but i realized it was not working for MATRIX view, and i remember to not 
using a filter in the table but in the measures itself. I adjusted 2 measure i used to this below. Now it's working 

[amitchandak]

@Anonymous , if you want two date/period slicer you need to follow disconneted table approch

Power BI Abstract Thesis: How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg