nerdexam
Microsoft

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.

Submitted by emma.c· Apr 18, 2026Implement and manage semantic models

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)
  • A
    3% (1)
  • B
    78% (31)
  • C
    13% (5)
  • D
    8% (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.

AUSERELATIONSHIP()

USERELATIONSHIP() is used to activate an *existing* but inactive relationship between tables, not to create a virtual relationship where none exists.

BTREATAS()Correct

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.

CPATH()

PATH() is used to work with parent-child hierarchies within a single table, not to establish relationships between different tables.

DCROSSFILTER()

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

#DAX#Virtual Relationships#TREATAS#Semantic Models

Community Discussion

No community discussion yet for this question.

Full DP-600 Practice