Edit

Share via


ISBOOLEAN

Applies to: Calculated column Calculated table Measure Visual calculation

Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.

Syntax

ISBOOLEAN(<value>)

Parameters

Term Definition
value The value that you want to test.

Return value

TRUE if the value is a logical value; FALSE if any value other than TRUE OR FALSE.

Remarks

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
  • This function is an alias of ISLOGICAL.

Example

The following DAX query shows the behavior of ISBOOLEAN.

EVALUATE
{
    IF ( ISBOOLEAN ( TRUE ), "Is Boolean type or Logical", "Is different type" ), // RETURNS: Is Boolean type or Logical
    IF ( ISBOOLEAN ( FALSE ), "Is Boolean type or Logical", "Is different type" ), // RETURNS: Is Boolean type or Logical
    IF ( ISBOOLEAN ( 42 ), "Is Boolean type or Logical", "Is different type" ) // RETURNS: Is different type
}