pbPassingBI
/

How do you handle a role-playing dimension like Date?

advanced
Answer

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