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
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership