Relationship Functions

Question 1

RELATEDTABLE(tableName)

Answer 1

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

Question 2

RELATED(column)

Answer 2

Returns a related value from another table.

Question 3

CROSSFILTER(columnName1, columnName2, direction)

Answer 3

Specifies the cross-filtering direction to be used in a calculation for a relationship that exists between two columns.

Question 4

USERELATIONSHIP(columnName1, columnName2)

Answer 4

Specifies the relationship to be used in a specific calculation as the one that exists between columnName1 and columnName2.