PowerPivot Denali: Working with multiple relationships between two tables

In the SQL server Denali release it will be possible to work with multiple relationships between two tables. Consider the following model based on adventureworks (using our new Diagram view):