DP-600 · Question #113
You are developing a Microsoft Power BI semantic model. Two tables in the data model are not connected in a physical relationship. You need to establish a virtual relationship between the tables. Whic
The correct answer is B. TREATAS(). To establish a virtual relationship between two physically unconnected tables in a Power BI semantic model for analytical purposes, the TREATAS() DAX function should be used.
Question
You are developing a Microsoft Power BI semantic model. Two tables in the data model are not connected in a physical relationship. You need to establish a virtual relationship between the tables. Which DAX function should you use?
Options
- AUSERELATIONSHIP()
- BTREATAS()
- CPATH()
- DCROSSFILTER()
How the community answered
(40 responses)- A3% (1)
- B78% (31)
- C13% (5)
- D8% (3)
Why each option
To establish a virtual relationship between two physically unconnected tables in a Power BI semantic model for analytical purposes, the TREATAS() DAX function should be used.
USERELATIONSHIP() is used to activate an *existing* but inactive relationship between tables, not to create a virtual relationship where none exists.
The TREATAS() DAX function applies the columns of a table as filters to the columns of an unrelated table. This allows calculations to be performed across tables that do not have a direct physical relationship or when the existing relationship is not suitable for the current context, effectively creating a virtual relationship for filtering purposes.
PATH() is used to work with parent-child hierarchies within a single table, not to establish relationships between different tables.
CROSSFILTER() is used to modify the cross-filter direction of an *existing* relationship, not to establish a virtual relationship between unconnected tables.
Concept tested: DAX virtual relationships (TREATAS)
Source: https://learn.microsoft.com/en-us/dax/treatas-function-dax
Topics
Community Discussion
No community discussion yet for this question.