Need to help filtering table between active and inactive relationship

Hi all,   I have a lookup table for departments and a fact table which contains 2 fields related to the department field.  Reporter department and responsible department.  The primary relationship ...