Forum Discussion

Zilver's avatar
Zilver
Regular Visitor
6 years ago
Solved

Show only matching values from multiple tables

Hi all, I have 2 tables like this :   Table 1 Ord_Number Status 10 D 20 D 30 D   Table 2 Ord_Number Status 40 U 50 U   and I have Table 3 have so many numbe...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Zilver , 

    You could create a table to union table1 and table2 's column, then create relationship between table3, then use not blank in filter, which will work.

    Or you also could use measure to achieve this goal(don't create relationship between new table and table 3). You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

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

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Zilver , 

You could create a table to union table1 and table2 's column, then create relationship between table3, then use not blank in filter, which will work.

Or you also could use measure to achieve this goal(don't create relationship between new table and table 3). You could refer to my sample for details.

Best Regards,
Zoe Zhi

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