Date slicer not passing start and end date when viewed from performance analyzer

[Anonymous]

Hi All,

I am having an issue in the date slicer values getting passed.

I have a date slicer which is type between

This comes from a DIm Date table.

The date table is related to a fact table.

Earlier on for a measure which is filtered for the selected dates, performance analyzer gives in the meaure query

VAR __DS0FilterTable =
FILTER(
KEEPFILTERS(VALUES('DIM-Date'[Date])),
AND('DIM-Date'[Date] >= DATE(2021, 12, 1), 'DIM-Date'[Date] < DATE(2022, 1, 1))
)

Suddenly I notice for the same measure the performance anayzer is showing in the query

  VAR __DS0FilterTable = 
    FILTER(
      KEEPFILTERS(VALUES('DIM-Date'[Date])),
      'DIM-Date'[Date] < DATE(2022, 1, 1)
    )

Any idea why this could have happened. Is it do something with the settings.

Need help urgently.

Cheers

CheenuSing

[amitchandak]

@Anonymous , I think because the date table is joined the filter in the slicer is already applied. The start date is the same so >= is already covered. Only diff in last date, to only that one is added 

[Anonymous]

@amitchandak ,

Even with the relationship , it was showing 

VAR __DS0FilterTable =
FILTER(
KEEPFILTERS(VALUES('DIM-Date'[Date])),
AND('DIM-Date'[Date] >= DATE(2021, 12, 1), 'DIM-Date'[Date] < DATE(2022, 1, 1))
)

I uninstalled and re-installed the Desktop app.

still the same.

Cheers

CheenuSIng