Problem with many to many lookup

I am having trouble creating a filter column based on a calcuation in another table. It is something I have done several times, but it just isn't working here.   Here is the basic structure of the ...