DAX function
RELATED — DAX function reference
Pull a value across a many-to-one relationship.
Syntax
dax
RELATED(<column>)
Examples
dax
RELATED(Product[Category])
→ A value
dax
Sales[Amount] * RELATED(Currency[ExchangeRate])
→ Currency-converted amount, in a calculated column
dax
IF(RELATED(Product[Discontinued]) = TRUE(), "Legacy", "Active")
→ Pulls a flag from the one side to classify each transaction row
Common mistakes & gotchas
- Used in a calculated column on the many side, reaching to the one side.
- RELATED only works across a many-to-one relationship, traveling from the many side to the one side, and only returns a value when exactly one related row exists — on a many-to-many or inactive relationship it returns BLANK() (USERELATIONSHIP does not help here since it only applies inside CALCULATE, not in a calculated column’s row context).
- It's evaluated in row context, so it belongs in calculated columns (or inside an iterator's row context) — a plain measure has no single 'current row' for RELATED to look from.
Related DAX functions
From Relationships