The OR function in DAX accepts only two (2) arguments. If you need to perform an OR operation on multiple expressions, you can create a series of calculations or, better, use the OR operator ( ) to join all of them in a simpler expression. The function evaluates the arguments until the first TRUE argument, then returns TRUE. All of the fonts you'll find alternatives for in this article are: Helvetica, Gotham, Trajan Pro, Bodoni MT, Museo Slab, Adelle, Clarendon, Dax Pro, Neutraface.
-->Applies the result of a table expression as filters to columns from an unrelated table.
Syntax
Parameters
Term | Definition |
---|---|
table_expression | An expression that results in a table. |
column | One or more existing columns. It cannot be an expression. |
Return value
Torrent manager download. A table that contains all the rows in column(s) that are also in table_expression.
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.
Examples
In the following example, the model contains two unrelated product tables. If a user applies a filter to DimProduct1[ProductCategory] selecting Bikes, Seats, Tires, the same filter, Bikes, Seats, Tires is applied to DimProduct2[ProductCategory].