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 but i want to all be based on the 1 filter.  Is this possible and how ? 

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])
))

3 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    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])