How does the OR function (DAX) work?

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

OR Formula Syntax

OR(
     <logical1>,<logical2>)
)

How do you use the OR function?

The OR function in DAX only accepts two (2) arguments. If you need to perform an OR action on several expressions, you can create a series of calculations or, better, use the OR operator (II) in a simpler expression to combine all of these.

The function evaluates the arguments until the first TRUE argument, then returns TRUE.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the OR function

A Boolean value. The value is TRUE if either of the two arguments is TRUE; if both the arguments are FALSE, the value is FALSE.

Related Video Tutorials

Formula examples using the OR function

= OR (Results[Medal Count]>150,Results[Count of Sport]>150)
= OR ([Medal Count]<500, [Count of Sport]>100)
Both the above DAX formulas return True as [Count of Sport] > 100 is True.
OR ([Medal Count]<500, [Count of Sport]<100)
Returns False as both arguments are False.

Related DAX Functions

Related Course Modules

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.