thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

USERELATIONSHIP Function

A DAX modifier used in CALCULATE that activates an inactive relationship for one calculation.

Definition

Power BI allows only one active relationship between two tables, and others are inactive (shown as dashed lines). USERELATIONSHIP enables measures such as Sales by Ship Date.

Example

Sales by Ship Date = CALCULATE([Total Sales], USERELATIONSHIP(Sales[ShipDate], 'Date'[Date]))

Exam tip

Two date columns related to one date table = one active relationship + USERELATIONSHIP in measures.

Related terms