Forum Discussion
Cross Filtering between 2 dimensional tables
Hi we have a Club/Store dimension and an Employee dimension. The need is for us to be able to cross filter allowing our Club/Store filter to filter down the list that show in our Employee filter given the large amount of Employees that show. We are trying very hard to adhere to proper dim Star schema building...it appears the Pbix does not establish any relationship to filter.
Hi, jdeharo
Based on your information, I create sample tables:
Select the Manage Relationship, and edit relationship
Set the Cross filter direction to Both.If needed, select Apply security filter in both directions.
Create Filters, test the filters to ensure that selecting a Club/Store filters the Employee list accordingly. For example, selecting “Store A” should only show Alice and Charlie.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Can you move the fields from the Club/Store table onto the employee table rather than having it in a separate table?
Hi, jdeharo
Based on your information, I create sample tables:
Select the Manage Relationship, and edit relationship
Set the Cross filter direction to Both.If needed, select Apply security filter in both directions.
Create Filters, test the filters to ensure that selecting a Club/Store filters the Employee list accordingly. For example, selecting “Store A” should only show Alice and Charlie.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
