Report Portal

Propagate filters using TREATAS in DAX

This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or FILTER.


A virtual relationship is a DAX pattern to transfers a filter context from a table to another, simulating the behavior of a physical relationship defined in the data model. This technique is useful whenever a relationship does not exist, or when it cannot be created because the relationship is not a one-to-many, or because it is defined by two or more columns. You can find a longer description in the article Physical and Virtual Relationships in DAX.



Tags: performance, dax, tabular


2007-2015 VidasSoft Systems Inc.