Not able to filter by single date the table and Gant Chart

[skv17]

Hi Power BI nerds,

I am trying to filter the table by a specific date , which is working fine for the table but the gantt chart does not update as per the date filter.

so i have used this to do the sum in minutes and the filter for dates in between two dates :

Duration in Fence = CALCULATE(SUM('Fleetsu Time Asset In Fence'[Duration in Fence Minutes]),FILTER('Fleetsu Time Asset In Fence','Fleetsu Time Asset In Fence'[Entered_EventTimeStamp]<=MAX('Date DIM 2'[Date 2])&&'Fleetsu Time Asset In Fence'[Exited_EventTimeStamp]>MAX('Date DIM 2'[Date 2])))   --- this filters the table when the measure is added into the table but the gant chart does not update ,  i will attach the pbix and excel file 

[skv17]

https://drive.google.com/drive/folders/1kg8W5xOwuwDaM3ckNCPj10T5VmfiDTc_?usp=sharing  

link to the files above