Multiple Date filter/ relationship

timazarj , can you check InsertedDate has a timestamp. If so join might fail

create a date like 

Date = [InsertedDate ].date
or
Date = date(year([InsertedDate ]),month([InsertedDate ]),day([InsertedDate ]))

Hello timazarj 
You can try few things.
1. Check the column format and make it date.
2. Mark the date table as a date table.
3. Check the min and max of both the Inserted Date and Effective Date and create the date table accordingly using min and max values.

4. Create an active relationship with the inserted date and modify the measure accordingly and check.