Export (0) Print
Expand All

RELATEDTABLE Function

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])
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft