OpenBI Docs Buy

FALSE

Boolean false, as FALSE() writes it.

Group: Logical. Compatible with DAX.

Syntax

FALSE ( )

It takes no parameters.

Returns

Boolean. FALSE.

Remarks

  • FALSE without the brackets means the same.
  • In arithmetic FALSE is 0, so FALSE () * 3 is 0.
  • A logical value is not compared with a number: FALSE () = 0 is an error. A blank, though, equals FALSE under =.

Examples

Two ways to write it, and as a number

EVALUATE
ROW ( "FALSE ()", FALSE (), "FALSE", FALSE, "Times 3", FALSE () * 3, "Blank = FALSE", BLANK () = FALSE () )
FALSE ()FALSETimes 3Blank = FALSE
FALSEFALSE0TRUE

Rows where a condition is FALSE

EVALUATE
VAR Lines = DATATABLE ( "Liters", INTEGER, { { 40 }, { 250 }, { 1200 }, { 0 } } )
RETURN
    ROW ( "Not over 100", COUNTROWS ( FILTER ( Lines, ( [Liters] > 100 ) = FALSE () ) ) )
Not over 100
2

TRUE, NOT, IF, AND.

Last updated · OpenBI Studio 0.3.74