Filtering matching values

[Anonymous]

I am trying to filter my visual which contains two columns of customers from different tables.

When the two columns do not have the same value on a row level they should dissappaer from the visual.

The two underlying tables do not have any kind of relation.

Does someone know a possible solution to this?

Kind regards,

Ricardo

[Anonymous]

Great! That solved my problem like it was nothing!

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

As far as my test, if the two tables don't have any kind of relationship, their columns will not be able to be placed in the same visual, it will get the below error.

I guess maybe the two tables are not directly related, but can be related by other tables.

Here's my solution, create a measure.

Check = IF(MAX('Table'[Customer])=MAX('Table (2)'[Customer]),1)

Put the measure in the visual filter, and select its value to 1 like below.

After clicking Apply filter, get the result.

I attach my sample below for 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.