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
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
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
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.