Visual Filter using a a value from a column after looking up another table
I need some dax that I can use as a visual filter to filter out rows based on this logic.
I want to filter Table 1 rows, If the record exists in Table 1 and Table 2 then filter out all rows from Table 1 with the same Table1 Sort value.
Looking at the Ref column in both tables we can see A1001 exists in both tables. From here I need to find the value in the Sort Column for Ref A1001 and whatever that value is, filter all rows with that value. In this case that is value 1, removing 3 rows.