This topic has not yet been rated - Rate this topic

RELATEDTABLE Function

SQL Server 2012

Evaluates a table expression in a context modified by the given filters.


RELATEDTABLE(<tableName>)

Term	Definition
tableName	The name of an existing table using standard DAX syntax. It cannot be an expression.

A table of values.

The RELATEDTETABLE 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.

The following example uses the RELATEDTABLE function to create a calculated column with the Internet Sales in the Product Category table.

The following table shows the results of using the code shown here.

Product Category Key	Product Category AlternateKey	Product Category Name	Internet Sales
1	1	Bikes	$28,318,144.65
2	2	Components
3	3	Clothing	$339,772.61
4	4	Accessories	$700,759.96

= SUMX( RELATEDTABLE('InternetSales_USD')
     , [SalesAmount_USD])

CALCULATETABLE Function

Filter Functions (DAX)

Relationships Between Tables

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions