How to handle many to many relation ship between two dimensions user and company

[adeelnazir]

I've following tables 

• User (user id, name) - this dimension table contains all users (simple or company owners)
• Company (CompId, name) - this dimension table contains only company details
• CompanyOwner (CompId, UserId, other detail) - this dimension table contains the company owner users only details
• Fact (userId, compId)

RelationShips

• User one-many Fact
• Company one-many Fact
• User one-many CompanyOwner
• Company one-many CompanyOwner

I've two slicers 

• Company
• User

Now requirement is

1. when I click on User then company slicer should be filtered - this is done by applying >0 total rows check on a visual level filter
2. When a user slicer interaction is blocked on all other visuals except company slicer. So When a user is selected then the company slicer should be filtered and cards and visuals should show only filtered companies' data shown in the slicer not all. By doing 1st step I'm able to filter company slicer values but how can I filter all visuals/bars/cards data based on companies listed in the slicer?

[v-alq-msft]

Hi, @adeelnazir 

Could you please show us some sample data and expected results with OneDrive for business? Do mask sensitive data before uploading. Thanks.

Best Regards

Allan