RELATEDTABLE Function (DAX)
Evaluates a table expression in a context modified by the given filters.
RELATEDTABLE(<tableName>)
Parameters
| Term | Definition |
|---|---|
| tableName | The name of an existing table using standard DAX syntax. It cannot be an expression. |
A table of values.
The RELATEDTETABLE function changes the context in which the data is filtered, and evaluates the expression in the new context that you specify.
This function is a shortcut for CALCULATETABLE function with no logical expression.
The following example uses the RELATEDTABLE function to create a calculated column with the Internet Sales in the Product Category table.
The following table shows the results of using the code shown here.
| Product Category Key | Product Category AlternateKey | Product Category Name | Internet Sales |
| 1 | 1 | Bikes | $28,318,144.65 |
| 2 | 2 | Components | |
| 3 | 3 | Clothing | $339,772.61 |
| 4 | 4 | Accessories | $700,759.96 |
= SUMX( RELATEDTABLE('InternetSales_USD')
, [SalesAmount_USD])
Community Additions
ADD
Show: