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: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/and-function-dax