Forum Discussion

thhmez7's avatar
thhmez7
Helper III
3 years ago
Solved

Filtering two table columns without table relationships

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.   H...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    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

amitchandak's avatar
amitchandak
Super User
3 years ago

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