FIlter table based on values other table

[icturion]

hello,

Hopefully someone can help me with the following. I have two tables with a one-to-many relationship. Now the intention is to filter the records of table 1 based on certain column values ​​in table 2.

For exmple:

Table1

Table2

Column tbale 1 = If the ID in tabel 1 has A1 and A2 then Cat1 or B1 and B2 then Cat2 else emplty

My question is hoe to write this in Power BI

[v-lili6-msft · Accepted solution]

hi @icturion 

In table1, create a column as below:

and here is sample pbix file, please try it.

Regards,

Lin

[icturion]

Great this is exactly what i was looking for, thank you

[amitchandak]

@icturion , Make the join bi-directional in this case.

refer: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-bidirectional-filtering

[icturion]

Hello Amitchandak,

when I do that I only see the record that match in both tables. I don't have the solution with that. the intention is to show only those IDs that match the conditions.