ISBOOLEAN
Tells whether a value is one of the two logical values; another name for ISLOGICAL.
Group: Information. Compatible with DAX.
Syntax
ISBOOLEAN ( <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 any other value.
Remarks
- The same test as
ISLOGICAL, under the name of the newer family of type tests (ISSTRING,ISINT64...). - Only a logical value counts: 1 and 0 are numbers, "TRUE" is text, and a blank is none of them.
- A comparison such as
[Liters] > 100gives a logical value, so it is TRUE for that.
Examples
What counts as TRUE or FALSE
EVALUATE
ROW (
"TRUE ()", ISBOOLEAN ( TRUE () ),
"1 < 2", ISBOOLEAN ( 1 < 2 ),
"1", ISBOOLEAN ( 1 ),
"Blank", ISBOOLEAN ( BLANK () ),
"Text FALSE", ISBOOLEAN ( "FALSE" )
)| TRUE () | 1 < 2 | 1 | Blank | Text FALSE |
|---|---|---|---|---|
| TRUE | TRUE | FALSE | FALSE | FALSE |