RELATEDTABLE DAX Function (Relationships management)  Context Transition

Returns the related tables filtered so that it only includes the related rows.

Syntax

RELATEDTABLE ( <Table> )
Parameter Attributes Description
Table

The table that contains the desired value.

Return values

Table An entire table or a table with one or more columns.

A table of values.

Remarks

The RELATEDTETABLE function performs a context transition from row context(s) to a filter context, and evaluates the expression in the resulting filter context.
This function is a shortcut for CALCULATETABLE function with no additional filters, accepting only a table reference and not a table expression.

Related articles

Learn more about RELATEDTABLE 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

  • Understanding Context Transition

    The context transition in DAX is the transformation of row contexts into an equivalent filter context performed by CALCULATE and CALCULATETABLE. Managing this behavior is the next step in learning DAX once you understand row context and filter context. This article provides the basics of context transition. » Read more

Related functions

Other related functions are:

Last update: Oct 20, 2018   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Jes Hansen

MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/relatedtable-function-dax

DAX Conventions
Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

Row Context

This expression is executed in a Row Context. Click to read more.

Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

Not recommended

The use of this parameter is not recommended.

Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

Deprecated

This parameter is deprecated and its use is not recommended.

Contribute

Want to improve the content of RELATEDTABLE? Did you find any issue? Please, report it us!
All submissions will be evaluated for possible updates of the content.