Forum Discussion
Filtering is not applied to related tables
I want a filter from one table to apply to the releated data in other tables. Does anyone know how to set that up? I've added three unrelated tables and under Relationships I've linked the tables...
Eric_Zhang
Microsoft Employee
Microsoft Employee
Please ensure that "Cross filter direction" is applied as "Both".
Note: Relationship filtering is limited to a single direction in DirectQuery mode. So if in this mode, some tricky DAX expressions may have to be used to work around.
I switched over to Importing the data from SQL Svr and now the cross filter direction is enabled but still does not filter even after setting it to 'Both'. It still only filters in the one table. Let me know if there is something else I can try.
- Eric_Zhang