AND DAX Function (Logical)

Syntax  |  Return values  |  Remarks  |  Examples  |  Related  

Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.

Syntax

AND ( <Logical1>, <Logical2> )

Parameter	Attributes	Description
Logical1		The logical values you want to test.
Logical2		The logical values you want to test.

Return values

Scalar A single boolean value.

Remarks

The AND function accepts only two arguments. Consider using the operator && to avoid multiple nested calls in case there are three or more conditions to evaluate in a logical AND.

» 2 related functions

Examples

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

--  TRUE and FALSE are the two constant values of True and False (1, 0 ) --  AND performs the logical AND between two conditions --  OR performs the logical OR between two conditions --  NOT performs logical negation EVALUATE     {         ( "FALSE", FALSE ),         ( "FALSE()", FALSE() ),         ( "TRUE", TRUE ),         ( "TRUE()", TRUE() ),         ( "AND ( TRUE, FALSE )", AND ( TRUE, FALSE ) ),         ( "OR ( TRUE, FALSE )", OR ( TRUE, FALSE ) ),         ( "NOT ( TRUE )", NOT ( TRUE ) ),         ( "NOT ( FALSE )", NOT ( FALSE ) )            }

 Try it Copy#1

Value1	Value2
FALSE	false
FALSE()	false
TRUE	true
TRUE()	true
AND ( TRUE, FALSE )	false
OR ( TRUE, FALSE )	true
NOT ( TRUE )	false
NOT ( FALSE )	true

1 2 3 4 5 6 7 8 9

--  The AND function can be replaced with the && operator --  The OR function can be replaced with the || operator EVALUATE     {         ( "AND ( TRUE, FALSE )", AND ( TRUE, FALSE ) ),         ( "TRUE && FALSE", TRUE && FALSE ),         ( "OR ( TRUE, FALSE )", OR ( TRUE, FALSE ) ),         ( "TRUE || FALSE", TRUE || FALSE )     }

 Try it Copy#2

Value1	Value2
AND ( TRUE, FALSE )	false
TRUE && FALSE	false
OR ( TRUE, FALSE )	true
TRUE || FALSE	true

1 2 3 4 5 6 7 8 9 10 11

--  Operators are more convenient when you need to combine --  more than two conditions. EVALUATE     VAR A = TRUE     VAR B = FALSE     VAR C = TRUE RETURN     {         ( "Using AND", AND ( A, AND ( B, C ) ) ),         ( "Using &&",  A && B && C )     }

 Try it Copy#3

Value1	Value2
Using AND	false
Using &&	false

Related functions

Other related functions are:

• NOT
• OR

Last update: Mar 24, 2025   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/and-function-dax