ISLOGICAL
TRUE for a Boolean value, FALSE for anything else.
Group: Information. Compatible with DAX.
Syntax
ISLOGICAL ( <value> )| Parameter | Type | Description |
|---|---|---|
value | Value | What is tested: a constant, a column in a row context, a measure or any expression. |
Returns
Boolean. TRUE when the value is TRUE or FALSE, FALSE for numbers, text, dates and blanks.
Remarks
- The value's type decides, not what it reads like: the number 1 and the text "TRUE" are not logical values.
- A blank is not a logical value either: FALSE.
ISBOOLEANis the same test.
Examples
Values of several types
EVALUATE
ROW (
"TRUE ()", ISLOGICAL ( TRUE () ),
"3 > 2", ISLOGICAL ( 3 > 2 ),
"1", ISLOGICAL ( 1 ),
"Text TRUE", ISLOGICAL ( "TRUE" ),
"Blank", ISLOGICAL ( BLANK () )
)| TRUE () | 3 > 2 | 1 | Text TRUE | Blank |
|---|---|---|---|---|
| TRUE | TRUE | FALSE | FALSE | FALSE |