Ignoring Specific Filter not working in a pivot table when using the valuelist.

[Anuhya_kotha]

Hi All,
I am facing an issue in the below expression:

When I use the below expression as a measure with Year and Year Period as dimensions in the Pivot Table, selecting the current year in the filter pane correctly displays values starting from October 2023.

Num(Sum({<[Division Name]={'PEM Danboro'},[%DateKey]={">=$(=vMinSaleDate)<=$(=vMaxSalesDate)"},Year=,[Year Period]=,[Sales Type]={'Trade'}>}
if(vCurrencyType='EUR',[Sales EUR],if(vCurrencyType='CNY',[Sales CNY],[Sales USD])))/1000000,if(vCurrencyType='EUR','€ #,##0.00 M;(€ #,##0.00 M)',IF(vCurrencyType='CNY','¥#,##0.00 M;(¥#,##0.00 M)','$#,##0.00 M;($#,##0.00 M)')))

However, when I apply the below expression in a pivot table with ValueList and Year Period as dimensions, I only see values for the selected year, rather than including prior periods as expected.

if(
ValueList('Backlog ($)','Sales ($)','Bookings ($)')='Backlog ($)',
Num(Sum({<[Division Name]={'PEM Danboro'},[%DateKey]={">=$(=vMinSaleDate)<=$(=vMaxSalesDate)"},Year=,[Year Period]=,[Sales Type]={'Trade'}>}
if(vCurrencyType='EUR',[Backlog EUR],if(vCurrencyType='CNY',[Backlog CNY],[Backlog USD])))/1000000,if(vCurrencyType='EUR','€ #,##0.00 M;(€ #,##0.00 M)',IF(vCurrencyType='CNY','¥#,##0.00 M;(¥#,##0.00 M)','$#,##0.00 M;($#,##0.00 M)'))),
if(ValueList('Backlog ($)','Sales ($)','Bookings ($)')='Sales ($)',
Num(Sum({<[Division Name]={'PEM Danboro'},[%DateKey]={">=$(=vMinSaleDate)<=$(=vMaxSalesDate)"},Year=,[Year Period]=,[Sales Type]={'Trade'}>}
if(vCurrencyType='EUR',[Sales EUR],if(vCurrencyType='CNY',[Sales CNY],[Sales USD])))/1000000,if(vCurrencyType='EUR','€ #,##0.00 M;(€ #,##0.00 M)',IF(vCurrencyType='CNY','¥#,##0.00 M;(¥#,##0.00 M)','$#,##0.00 M;($#,##0.00 M)'))),
if(ValueList('Backlog ($)','Sales ($)','Bookings ($)')='Bookings ($)',
Num(Sum({<[Division Name]={'PEM Danboro'},[%DateKey]={">=$(=vMinSaleDate)<=$(=vMaxSalesDate)"},Year=,[Year Period]=,[Sales Type]={'Trade'}>}
if(vCurrencyType='EUR',[Booked EUR],if(vCurrencyType='CNY',[Booked CNY],[Booked USD])))/1000000,if(vCurrencyType='EUR','€ #,##0.00 M;(€ #,##0.00 M)',IF(vCurrencyType='CNY','¥#,##0.00 M;(¥#,##0.00 M)','$#,##0.00 M;($#,##0.00 M)')))
)
)
)

Has anyone encountered a similar issue or have any suggestions?