ISLOGICAL Function (DAX)

How does the ISLOGICAL function (DAX) work?

ISLOGICAL function (DAX) checks if a value (TRUE or FALSE) is a rational value and returns TRUE or FALSE. It is part of a group of functions called the IS functions, usually used to evaluate the outcome of error formulas.

ISLOGICAL Formula Syntax

ISINSCOPE (<columnName>)

How do you use the ISLOGICAL function?

ISLOGICAL function returns TRUE when a cell contains the logical values TRUE or FALSE, and returns FALSE for cells that contain any other value, including empty cells.

Related Blog Posts

NEW-EXISTING-CUSTOMER-SALES

Related Support Forum Posts

Accessing Matrix hierarchy levels
Dynamic RANKX with Other Category
Developing Complex Dax functions

Considerations when using the ISLOGICAL function

ISLOGICAL is part of a group of functions called the IS functions, which are often used to test the result of formulas for errors.

Use the ISLOGICAL function to check if a value is logical. ISLOGICAL will return TRUE when a value is TRUE or FALSE.

Related Video Tutorials

Using-The-AVERAGEX-Function-DAX-Tutorial-Examples

Formula examples using the ISLOGICAL function

//RETURNS: Is Boolean type or Logical  
=IF(ISLOGICAL(true), "Is Boolean type or Logical", "Is different type")  
  
//RETURNS: Is Boolean type or Logical  
=IF(ISLOGICAL(false), "Is Boolean type or Logical", "Is different type")  
  
//RETURNS: Is different type  
=IF(ISLOGICAL(25), "Is Boolean type or Logical", "Is different type")  

Related DAX Functions

ISBLANK
ISERROR
ISEMPTY

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.