I just saw that ambiguous relationships are possible in Power BI. In the diagram below I would have expected that I get at least one inactive relationship or an error. But it actuallay works. Table 1 filters Table 3 on 2 paths. The resulting filter context for table 3 is the intersection of the filters that come through both relationsships. Is this new behaviour in Power BI or just new to me?
The most relevant insight for me was that if you turn one relationship into an inactive relationship and then you turn that on with USERELATIONSHIP, in this setup it does not turn off the ambiguous relationship so that you might miss some data in the reuslt. If you want to make sure that only one relationship applies at a time you need to turn both relationships going to table 3 into inactive relationships.