DAX Filter - RELATEDTABLE function


Advertisements

Description

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

Syntax

RELATEDTABLE (<tableName>) 

Parameters

Sr.No. Parameter & Description
1

tableName

The name of an existing table.

It cannot be an expression.

Return Value

A table of values.

Remarks

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

DAX RELATEDTABLE function is equivalent to DAX CALCULATETABLE function with no logical expression.

Example

= SUMX (RELATEDTABLE (East_Sales),East_Sales[Sales Amount]) 
dax_functions_filter.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements