DAX Function Guide

RELATEDTABLE
Empty image or helper icon

Sam McKay

CEO & Founder

How does the RELATEDTABLE 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?

The RELATEDTABLE function changes the context in which the data is filtered, and evaluates the expression in the new context that you specify.

Related Blog Posts

Loading

Considerations when using the RELATEDTABLE?

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

Loading

Formula examples using the RELATEDTABLE

= SUMX( RELATEDTABLE(‘InternetSales_USD’) , [SalesAmount_USD])

=COUNTROWS(RELATEDTABLE(ResellerSales_USD))

= RELATED(‘Resellers'[CompanyName])

Related Courses

Loading