Forum Discussion

PowerBIspeed's avatar
PowerBIspeed
Frequent Visitor
4 years ago
Solved

One filter for 5 tables

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 ...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    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])
))
PowerBIspeed's avatar
PowerBIspeed
Frequent Visitor
4 years ago

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's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You could change each VALUES statement to instead be

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