Forum Discussion
Resolver IIFIlter table based on values other table
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
hi icturion
In table1, create a column as below:
and here is sample pbix file, please try it.
Regards,
Lin
4 Replies
- amitchandak
Super User
icturion , Make the join bi-directional in this case.
refer: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-bidirectional-filtering
icturionHello 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.
v-lili6-msftCommunity Support
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
