IF Statement Not Respecting Date Relationship Filter

I have run into a problem I cannot figure out and cannot seem to find an answer on google.   I have two tables 1) A date table This just has dates. It is a dimension table. For reproducing, you c...