DAX Function Guide

OR
Empty image or helper icon

Sam McKay

CEO & Founder

How does the OR 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?

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

Loading

Considerations when using the OR?

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

Loading

Formula examples using the OR

= 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 Courses

Loading