cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

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

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.

1 ACCEPTED SOLUTION
Super User
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.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Super User
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.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...