ISLOGICAL DAX Function in Power BI

The ISLOGICAL DAX function checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.

DAX Syntax ISLOGICAL(<value>)

The parameter value specified the value we want to test.

Example: Let’s create a measure named “ISLOGICAL Measure”.

DAX

The output of the above DAX code is shown below:

DAX

The output of the above DAX code is shown below:

DAX

The output of the above DAX code is shown below:

Key Notes

• The ISLOGICAL function only checks the data type, not whether a logical condition evaluates to true or false. For example, ISLOGICAL(FALSE()) returns TRUE.
• It evaluates numeric values (like 1 or 0) as numbers, not logicals. So ISLOGICAL(1) will return FALSE, even though 1 can often represent TRUE in binary logic.
• If the passed argument evaluates to a BLANK value, the ISLOGICAL function will return FALSE.