This happens because of data type incompatibility between relationship columns. As an example, Calendar table has data column and fact table has date time column, and we are making a relationship between those two columns filter won't work.

Make both data types same for date, pick date time or date for both columns.