The date lookup filter is a table calc.
Table calcs are only applicable within the sheet where it is being used. Table calcs are based on the underlying table of the sheet in question.
You can see why this is the case in your own workbook. The applicable values for [date] differ from sheet to sheet because the underlying table for each sheet contains different data.
You'll have to approach this visualization differently.
What are you really trying to achieve here?
Actually i have 2-3 sheets which consist of runningsum TC used and requirement is to filter those running sum with date filter(3-4 dates chosen) .
if i have 2 sheets
city : New york
city : California
Now i want to filter by dec 2017 and dec 2018
while preserving running sum values
so i am not able to use one date filter to filter 2 sheets