- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Filter - RELATEDTABLE function
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