Which function allows you to activate an inactive relationship between Date and ShipDateKey for a calculation?

Which function allows you to activate an inactive relationship between Date and ShipDateKey for a calculation?

• A. CROSSFILTER
• B. USERELATIONSHIP
• C. RELATED
• D. TREATAS

Answer: (B)

Activating an inactive relationship for a calculation is done with a context-modifying function that tells the engine to use a different existing relationship during that evaluation. If there is an inactive relationship between Date and ShipDateKey, you can use that path in a specific measure by wrapping your calculation in CALCULATE and adding USERELATIONSHIP(Date[Date], Shipments[ShipDateKey]). This temporarily activates the chosen relationship for that calculation, while leaving the model unchanged for other expressions. CROSSFILTER changes how filters flow across relationships but doesn’t select a different inactive path for a single measure. RELATED pulls data through the currently active relationship, not an inactive one. TREATAS creates a virtual relationship by mapping values between columns, rather than toggling an existing inactive relationship for calculation.

Activating an inactive relationship for a calculation is done with a context-modifying function that tells the engine to use a different existing relationship during that evaluation. If there is an inactive relationship between Date and ShipDateKey, you can use that path in a specific measure by wrapping your calculation in CALCULATE and adding USERELATIONSHIP(Date[Date], Shipments[ShipDateKey]). This temporarily activates the chosen relationship for that calculation, while leaving the model unchanged for other expressions.

CROSSFILTER changes how filters flow across relationships but doesn’t select a different inactive path for a single measure. RELATED pulls data through the currently active relationship, not an inactive one. TREATAS creates a virtual relationship by mapping values between columns, rather than toggling an existing inactive relationship for calculation.