Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
Yes, a reverse implied filter is possible. Technically, the T1 table filters T2 which filters T3. Only matching records are retained.
Yes, a reverse implied filter is possible. Technically, the T1 table filters T2 which filters T3. Only matching records are retained.
Thank You!
User | Count |
---|---|
79 | |
74 | |
44 | |
32 | |
28 |
User | Count |
---|---|
100 | |
93 | |
52 | |
50 | |
48 |