DAX Logical - OR function

Description

Checks whether one of the arguments is TRUE. Returns TRUE if at least one of the arguments is TRUE and returns FALSE if both the arguments are FALSE.

Syntax

OR (<logical1>, <logical2>) 

Parameters

Return Value

• TRUE if any of the two arguments is TRUE.
• FALSE if both the arguments are FALSE.

Remarks

DAX OR function takes only two arguments. If you have more than two arguments, either nest the OR functions or use the logical OR operator ||.

Example

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

Kickstart Your Career

Get certified by completing the course

Get Started