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:
Link to sample pbix here
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.
[Total: 0 Average: 0/5]
« Back to Index
Hi Ruth,
The link to the sample pbix file goes to sqlbi.com
Could you please check?
Thanks & Regards,
Kamal Mukhi
Hi,
Yes, it is meant to go there. You can download the example (similar) there 🙂
/Ruth