Cross Filtering between 2 dimensional tables

[jdeharo]

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.  

 Updating Media

[v-yohua-msft · Accepted solution]

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.

[jdbuchanan71]

Can you move the fields from the Club/Store table onto the employee table rather than having it in a separate table?