How do you handle a role-playing dimension like Date?
advancedAnswer
Only one relationship between two tables can be active on a given path. Create the additional relationships as inactive, then activate the one you need per measure with USERELATIONSHIP inside CALCULATE.
The alternative is importing the dimension several times — OrderDate, ShipDate, DueDate — which gives self-service users separate slicers but multiplies maintenance.
USERELATIONSHIP is the idiomatic answer and keeps a single dimension with a single set of attributes.
Related