Filter multiple tables based on Status not working

[marial16]

Hello,

i have the following case.

A table with 2 columns ID / Status has to filter 10 tables.

i would like to filter by status (1 = Active, 0=Inactive)

All those tables reffer to an employee.

There is another table named HR that has the Employee Name. All 10 tables have the Employee Name as a column.

HR is connected to all tables using employees Identification No.

I would like to select Status 1 from a slicer and filter All 10 tables

This is not working. It only works for 1 table.

Any help would be appreciated !

[FreemanZ]

Does the 10 table include HR table?

[marial16]

HR is connected to all tables since i need to get the employee Names

[FreemanZ]

It seem as the HR table and Employee Tables are interconnected, so Status is connected with other tables with an inactive relationship. By default , inactive relationship is not active and thus will not pass the filtering. So comes the issue you have. 

Inactive relationship could be temporally activated with USERELATIONSHIP, but considering the number of your tables, that would be a long code. 

Let's see what good proposals others may come up with.