TREATAS

Syntax

TREATAS(table_expression, <column>[, <column>[, <column>[,…]]]} )

Tutorial with example

In this video we will go through the DAX function TREATAS.
The TREATAS DAX function allows us to create virtual relationships within tables or pass filters to tables that are not related.

Download example file:

To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #66

Remarks

• The number of columns specified must match the number of columns in the table expression and be in the same order.If a value returned in the table expression does not exist in the column, it is ignored. For example, TREATAS({“Red”, “Green”, “Yellow”}, DimProduct[Color]) sets a filter on column DimProduct[Color] with three values “Red”, “Green”, and “Yellow”. If “Yellow” does not exist in DimProduct[Color], the effective filter values would are “Red” and “Green”.Best for use when a relationship does not exist between the tables.