Inactive relationship

An inactive relationship exists between two tables but is not used by default: only one active relationship is possible between two tables. You activate it occasionally in a DAX measure with USERELATIONSHIP, for example to analyze by delivery date rather than order date.

Example

Ventes livrées = CALCULATE([Total ventes], USERELATIONSHIP(Ventes[DateLivraison], 'Date'[Date]))

Related concepts

The whole glossary