Multiple Choice Difficult

QWhy might a Power BI developer use USERELATIONSHIP() in DAX?

ID: #25399 Introduction to Power BI 2 views
Question Info
#25399Q ID
DifficultDifficulty
Introduction to Power BITopic

Select All That Apply

Tick every correct option, then press Check Answer.

  • A To activate an inactive relationship for a calculation.
  • B To create a new workspace.
  • C To publish reports automatically.
  • D To improve dashboard colors.
Correct Answer

Explanation

Option A is correct because USERELATIONSHIP() temporarily activates an inactive relationship during a calculation. For example, a Sales table may have both Order Date and Ship Date relationships to a Date table, but only one can be active at a time. USERELATIONSHIP() allows calculations using the inactive relationship when needed. Options B, C, and D are unrelated.

Share This Question

Challenge a friend or share with your study group.