Forum Discussion

JoshoDotNZ's avatar
JoshoDotNZ
Frequent Visitor
6 years ago
Solved

Filter from multiple tables with multiple columns issue

Hey Squad,    Have hit a road block with PowerBI Filters. Since of how the model has been setup for the App, I am struggling to create a filter to filter departments from different tabels.  Divis...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    If there are more than one departments, like department 1 and department 2 in all your table. You can create two copies of the department. Like Employee Department, Sales Department.

    And use them. Unless you have to need to filter both the column on the same value

    You can create a copy of the same table. Create a new table as 

     

     

    Department Sales = Department

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

If there are more than one departments, like department 1 and department 2 in all your table. You can create two copies of the department. Like Employee Department, Sales Department.

And use them. Unless you have to need to filter both the column on the same value

You can create a copy of the same table. Create a new table as 

 

 

Department Sales = Department

 

 

JoshoDotNZ's avatar
JoshoDotNZ
Frequent Visitor
6 years ago

Hey amitchandak,

 

Sorry struggling to understand, I have copied the Department table and tried to create a realationship but still get the same issues.

Is it possible for you to give me a example in a few picutes? Sorry more of a visaul learner.

 

Thanks,

Josh Griggs