Filtering the data in 1st table based on 2nd table

[Anonymous]

Hi Community,

There are two tables, 
The output from the 2nd table should be filtered based on 1st table values.

1st table :

C	C1	C2	C3
S	A	T	U

2nd table:

C	C1	C2	C3
A	A	T	U
B	A	T	U
C	A	S	T
D	B	B	D
E	C	X	V

Here, Columns C1, C2 and C3 from the 1st table need to be filtered in the 2nd table and output should be all the columns in the 2nd table.

Output:

C	C1	C2	C3
A	A	T	U
B	A	T	U

Kindly help by through DAX.

Regards,
Vineetha.

[Greg_Deckler · Accepted solution]

So, I am thinking that you might want to create a key column in both tables that is essentially:

Key Column = [C1] & [C2] & [C3]

Create a relationship between the tables based on the key column. Then you should be good to go.