Advanced filtering with a date, filters out too much

[travelwithme]

Anybody experienced this behaviour where the advanced date filter filters out too many rows?

SQL: SELECT * FROM table WHERE startdate <= '2022-05-31';

Filter: none

=> 24.207 rows

SQL: SELECT * FROM table;
Filter: startdate is on or before 5/31/2022 12:00:00 AM

=> 24.195 rows

[amitchandak · Accepted solution]

@travelwithme , You use a visual level filter or create a measure

countrows(filter(Table, Table[date] <= date(2022,5,31) ) )