RELATEDTABLE is a DAX function that returns a filtered related table containing only rows related to the current row.
RELATEDTABLE( Table )| Argument | Properties | Description |
|---|---|---|
| Table | The table that contains the desired value. |
A table of values.
The RELATEDTABLE 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.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
The following example uses the RELATEDTABLE function to create a calculated column with the Internet Sales in the Product Category table:
= SUMX( RELATEDTABLE('InternetSales_USD')
, [SalesAmount_USD])
The following table shows the results:
| 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 |
Other functions related to RELATEDTABLE are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy