Main dimension inactive relationship

[michaelshparber]

I manage sales reports for several Companies using same tables.

I have a "Companies" dimension with which I want to manage row-level security.

So I want it to filter by relationship both Products and Customers dim tables, which, it turn, filter the Sales table...

But Power BI doesn't let me have two active relationships and I cannot understand why... I don't see any conflict with filtering flow...

What do I miss and how to do this right?

Attached below is the link to file

Thanks!

https://1drv.ms/u/s!AoP_9ampPIT79T8YItyxu47MBGH8?e=Uqcsjp

[amitchandak]

@michaelshparber , Because then there will two paths to reach from company to sales. That is why on join is inactive to make sure one path is active.

I would advise you to prefer star schema and join the company with sales. In case you want to filter products and customers based on the company. Take sales measures from sales and use that in the visual filter for products and customers for nonblank.

refer this video : https://www.youtube.com/watch?v=cyOquvfhzNM

[michaelshparber]

I don't want to filter non blank, there are products and customers without sales and I want them to be shown for instance in slicers.

Also, I don't want to filter a measure in each and every visual...

I need a more simple and robust solution, any ideas?