View data opposite to filtered data

Hi Syndicate_Admin ,

According to your description, I create a sample.

Here's my solution.

1.Create a new table, don't make relationship between the two tables.

Table 2 = VALUES('Table'[Art.Si Comprados])

Note in the new table, you can double click the column name and modify it to Art.No Comprados.

2.Create a measure.

Measure =
IF (
    MAX ( 'Table 2'[Art.No Comprados] ) IN VALUES ( 'Table'[Art.Si Comprados] ),
    1,
    0
)

Put the Art.No Comprados column in a visual and put the measure in the visual filter, then set its value to1, get the result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.