DAX Filter - RELATEDTABLE function
Advertisements
Description
Evaluates a table expression in a context modified by the given filters.
Syntax
RELATEDTABLE (<tableName>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
tableName The name of an existing table. It cannot be an expression. |
Return Value
A table of values.
Remarks
DAX RELATEDTETABLE function changes the context in which the data is filtered, and evaluates the expression in the new context that you specify.
DAX RELATEDTABLE function is equivalent to DAX CALCULATETABLE function with no logical expression.
Example
= SUMX (RELATEDTABLE (East_Sales),East_Sales[Sales Amount])
dax_functions_filter.htm
Advertisements