Filter All Pages using an Identical Column from Multiple different Tables

[CaveOfWonders]

Hi All, please excuse my ignorance, I am very new to Power BI and need some help with filtering. As you can see from the image below, I have around 20-30 tables (currently unrelated). However, every table has a column called Element consisting of the same values (Value 1 = A - Value 2 = B).

I want to filter all pages on the report based on the value in this column, but I want to be able to have one filter that filters all Element columns in all tables. Is this possible?

[V-lianl-msft · Accepted solution]

Hi @CaveOfWonders ,

You can create a new table and de duplicate "element", and then use "element" to create relationships with other tables. Then apply the new "element" to the report level filter.

Table 2 = DISTINCT(SELECTCOLUMNS(Sheet1,"element",Sheet1[element]))

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

I did not get it. But you should create a common Element dimension and join all table elements with this.

Refer

https://docs.microsoft.com/en-us/power-bi/guidance/