Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Alina_A
New Member

Filtering against cardinaliy, version May 2024

Hi, I am confused. I can filter against the cardinality of the relationship while I should not.

The situation is the following. I have 3 talbes (Table1 - T1 and so forth). T1- Personal_Data: employee_name, age, etc., T2- Employees: ID, employee_name, etc., T3- Children: employee_name, name_of_the_child (T3 is only for employees with children). Thus, T1 to T2 is one-to-one and T2 to T3 is one-to-many (one way cadinality from T2 to T3 - NOT bidirectional). And surprisingly I can make charts with data from T3 to T2 direction. In particular, I can make a chart with T3.employee_name and T1.age. And as far as I know, I should not be able to do so due to cardinality from T2 to T3 and not vice versa. I am using a version 2.129.1229.0 64-bit (May 2024). Is it working properly?

1 ACCEPTED SOLUTION

Yes, a reverse implied filter is possible. Technically, the T1 table filters T2 which filters T3. Only matching records are retained. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

2 REPLIES 2

Yes, a reverse implied filter is possible. Technically, the T1 table filters T2 which filters T3. Only matching records are retained. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Thank You!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors