Filtering two table columns without table relationships

[thhmez7]

Hi,

due to complexity of my data modell, two tables with same fields have no relationship. 

However in the report, I still want the fields Product of each table to filter each other.

How can this be achieved by creating a new product column that filters the other field of the other table?

Thank you.

[SebSchoon1]

You could create a product Table containing all the items you need to have.

Then add to model and add relationship

[amitchandak · Accepted solution]

@thhmez7 ,

If they do not have any relationship, create a slicer on one table say table 1

so measure for table 1 is

countrows(Table1)

use this in visual with any column of Table 1

Measure for table 2

countrows(Filter(Table2, Table2[product] in values(Table1[product]) )) 

Option 2

You need to have a table with all products like

product = distinct(Union(distinct(Table1[product ]), distinct(Table2[product ])) )

Join with both tables and filter