Question

You are building a DAX query in a Fabric semantic model. The 'Budget' table stores a 'RegionName' column but has no physical relationship to the 'Sales' table, which also contains a 'RegionName' column. You need to write a measure that returns the sum of Sales amounts filtered by the RegionName values currently present in the Budget table's filter context, without creating a physical relationship. Which DAX function should you use to propagate the filter?

Accepted Answer

Use TREATAS to apply the Budget RegionName values as a filter onto the Sales RegionName column.

Answer

Use RELATED to pull the RegionName from the Budget table into the Sales table.

Answer

Use USERELATIONSHIP to activate an inactive relationship between Budget and Sales.

Answer

Use CROSSFILTER to change the filter direction between the two tables.