How does the RELATEDTABLE function (DAX) work?
The RELATEDTABLE function (DAX) evaluates a table expression in a context modified by the given filters.
RELATEDTABLE Formula Syntax
How do you use the RELATEDTABLE function?
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.
Related Blog Posts
Related Support Forum Posts
Considerations when using the RELATEDTABLE function
Because the RELATEDTABLE function returns a table, not a single value, it must be used as an argument to a function that performs operations on tables.
Related Video Tutorials
Formula examples using the RELATEDTABLE function
= SUMX( RELATEDTABLE(‘InternetSales_USD’) , [SalesAmount_USD])
Related DAX Functions
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.