Filtering by multiple columns at once dynamically

[thampton]

I have a dim table and two fact tables. My dim table has three columns, ill use the below as an example. 

Zone |                     Market                       | State

Eastern                  Midwest                           IN

Eastern                  Midwest                           IL

My two fact tables have every column above. I want to create the mapping to where i have 3 slicers that work dynamically. So if i choose eastern in the first slicer, the second slicer filters itself to only markets and states in the eastern zone. When i try to create the mappings between the dim and fact tables, it only allows me to have 1 active relationship. It errors out when creating the last two. 

Any ideas? 

[mahoneypat · Accepted solution]

That should be the default behavior.  You would make a relationship on the State column (the most specific one), then you can add the three slicers from the Dim table.  Does that work?

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat