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

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Prepare for the Fabric Analytics Engineer Associate Test with comprehensive materials. Explore flashcards, multiple choice questions, and detailed explanations. Get ready for your success!

Multiple Choice

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

Explanation:
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.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy