One filter for 5 tables

[PowerBIspeed]

Hi,

I want to use 1 filter (slicer) wich has the article nr to choice.

Now I have 5 different tables but all have the column article nr . The data wil also be showned in 5 different table views but i want to all be based on the 1 filter.  Is this possible and how ? 

[PowerBIspeed]

That's the result i wanted but also raises a next question.

The filter filters all the tables in one click but i also want to have a filter on ordernr. When the order nr. is selected it should only shows the articles from this order in the article filter ! 

Thank you johnt75 for this help already.

[johnt75]

You could change each VALUES statement to instead be

SELECTCOLUMNS( 'Table', "article nr", 'Table'[article nr], "order nr", 'Table'[order nr])

[johnt75 · Accepted solution]

Create a dimension table for the article numbers, link it to each of the other tables and use that as the filter.

Article No Table = DISTINCT( UNION(
VALUES( 'Table1'[article nr]),
VALUES( 'Table2'[article nr]),
VALUES( 'Table3'[article nr]),
VALUES( 'Table4'[article nr]),
VALUES( 'Table5'[article nr])
))