AND DAX Function (Logical)
Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Logical1 |
The logical values you want to test. |
|
| Logical2 |
The logical values you want to test. |
Return values
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.
Examples
-- 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 ) )
}
| Value1 | Value2 |
|---|---|
| FALSE | false |
| FALSE() | false |
| TRUE | true |
| TRUE() | true |
| AND ( TRUE, FALSE ) | false |
| OR ( TRUE, FALSE ) | true |
| NOT ( TRUE ) | false |
| NOT ( FALSE ) | true |
-- 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 )
}
| Value1 | Value2 |
|---|---|
| AND ( TRUE, FALSE ) | false |
| TRUE && FALSE | false |
| OR ( TRUE, FALSE ) | true |
| TRUE || FALSE | true |
-- 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 )
}
| Value1 | Value2 |
|---|---|
| Using AND | false |
| Using && | false |
Related functions
Other related functions are:
Last update: Oct 22, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/and-function-dax
