RELATEDTABLE Function (DAX)

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

RELATEDTABLE(
     <tableName>
)

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

Use related and relatedtable Measures
Related Function and relationships
Measures not calculating sum in matrix

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])

=COUNTROWS(RELATEDTABLE(ResellerSales_USD))

= RELATED(‘Resellers'[CompanyName])

Related DAX Functions

calculatetable

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership