Inconsistent drillthrough behavior in Power Pivot and SSAS Tabular

If two or more relationships exist between two tables, knowing which relationship is active is not enough to determine the drillthrough behavior of your model. As a consequence, if you change the active relationship in your model, you may observe unexpected drillthrough behaviors. Consider the following diagrams, based on the same model.