How to filter through a segmented view of two different tables in Power BI Desktop.

[Nathan_Jaouen]

Hello Power BI community.

I have two tables that have columns with the same name. Can I create a segment (filter) that filters both the first and the second table?

I was going to use the relationships from the model part but only a link is possible with this system. My goal is to link at least two columns from two different tables.

I thank you in advance for all the answers you can give me.

[amitchandak · Accepted solution]

@Nathan_Jaouen , Create a common table

segment= distinct(union(distinct(Table1[segment]),distinct(Table2[segment])))

Join both tables with common tables

https://www.seerinteractive.com/blog/join-many-many-power-bi/