Filter a table based on measure with multiple OR's

Dear all,   I am trying to filter a table based on the measure pasted below. A row from the table 'sheet1' should be shown in the table if: the column 'parent link' contains the string as defined...