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