RELATED DAX Function (Relationships management)
Returns a related value from another table.
Syntax
Parameter | Attributes | Description |
---|---|---|
ColumnName |
The column that contains the desired value. |
Return values
A single value that is related to the current row.
Remarks
The RELATED function requires that a regular 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. The RELATED function cannot be used to fetch a column across a limited relationship.
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.
» 1 related function
Examples
-- RELATED is needed to access columns of the expanded table DEFINE MEASURE Sales[Sales Amount] = SUMX ( Sales, Sales[Quantity] * Sales[Net Price] ) MEASURE Sales[Sales at List Price] = SUMX ( Sales, Sales[Quantity] * RELATED ( 'Product'[List Price] ) ) EVALUATE SUMMARIZECOLUMNS ( 'Date'[Calendar Year], "Sales Amount", [Sales Amount], "Sales at List Price", [Sales at List Price] )
Calendar Year | Sales Amount | Sales at List Price |
---|---|---|
2007-01-01 | 11,309,946.12 | 12,457,410.85 |
2008-01-01 | 9,927,582.99 | 11,031,426.30 |
2009-01-01 | 9,353,814.87 | 10,201,311.36 |
Related articles
Learn more about RELATED in the following articles:
-
Row Context and Filter Context in DAX
Understanding the difference between row context and filter context is important in using DAX correctly. This article introduces these two concepts. » Read more
-
Lookup multiple values in DAX
This article describes different techniques to retrieve multiple values from a lookup table in DAX, improving code readability and performance. » Read more
Related functions
Other related functions are:
Last update: Sep 14, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/related-function-dax