RELATED Function (DAX)
How does the RELATED function (DAX) work?
The RELATED function (DAX) returns a related value from another table.
RELATED Formula Syntax
RELATED(
<column>
)
How do you use the RELATED function?
The RELATED function needs a row context; therefore, it can only be used in calculated column expression, where the current row context is unambiguous, or as a nested function in an expression that uses a table scanning function. A table scanning function, such as SUMX, gets the value of the current row value and then scans another table for instances of that value.
Related Blog Posts
Considerations when using the RELATED function
The RELATED function requires that a relationship exists between the current table and the table with related information. The argument specifies a column reference, and the function follows a chain of one or more many-to-one relationships to fetch the value from the specified column in the related table. If a relationship does not exist, RELATED raises an error.
Related Video Tutorials
Formula examples using the RELATED function
SUMX(Products ,Products[Unit Price] * RELATED(‘Stock Levels’ [QTY]))
=related(pricelist[Price per unit])
=related(DimPlayerRole[PlayerRole])