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

Related Support Forum Posts

Related Function and relationships
Active relationships using DAX
Case Sensitive Relationships

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])

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership