Which function applies the result of a table expression as filters to columns from an unrelated table?

Which function applies the result of a table expression as filters to columns from an unrelated table?

• A. CROSSFILTER()
• B. PATH()
• C. USERELATIONSHIP()
• D. TREATAS()

Answer: (D)

TREATAS applies the results of a table expression as filters to columns in another table, even when there’s no physical relationship between the two tables. It takes values from a source table expression (like VALUES or a subquery) and maps them onto one or more target columns, creating a virtual filter context during evaluation. This lets you push a set of values into filtering for a separate table inside CALCULATE or similar expressions. CROSSFILTER only changes how an existing relationship propagates filters between related tables, PATH builds hierarchy paths, and USERELATIONSHIP forces the use of an alternate existing relationship. So, TREATAS is the function that applies those table-expression results as filters to an unrelated table.

TREATAS applies the results of a table expression as filters to columns in another table, even when there’s no physical relationship between the two tables. It takes values from a source table expression (like VALUES or a subquery) and maps them onto one or more target columns, creating a virtual filter context during evaluation. This lets you push a set of values into filtering for a separate table inside CALCULATE or similar expressions.

CROSSFILTER only changes how an existing relationship propagates filters between related tables, PATH builds hierarchy paths, and USERELATIONSHIP forces the use of an alternate existing relationship. So, TREATAS is the function that applies those table-expression results as filters to an unrelated table.