Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

Filter multiple tables based on Status not working



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 !


Super User
Super User

Does the 10 table include HR table?

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

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. 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors