Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filtering matching values

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. ...
General Comment
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

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.