OR DAX Function in Power BI

The OR DAX function checks whether one of the arguments is TRUE to return TRUE. The function returns FALSE if both arguments are FALSE.

DAX Syntax OR(logical1, logical2)

The logical_1, logical_2 are the parameters and the logical values we want to test.

Note: • The OR function in DAX accepts only two (2) arguments. If we need to perform an OR operation on multiple expressions, we can create a series of calculations or, better, use the OR operator (||) to join all of them in a simpler expression.
• We can use OR function in nested also means OR function inside the other OR function.
• The function evaluates the arguments until the first TRUE argument, then returns TRUE.

Example: Let’s create a measure named “OR Measure”.

DAX

OR Measure = OR(5>5, 6>2)

The output of the above dax function is shown below:

Previous Next