Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Checks if a value is not text (blank cells are not text), and returns TRUE or FALSE.
Syntax
ISNONTEXT(<value>)
Parameters
| Term | Definition |
|---|---|
value |
The value you want to check. |
Return value
TRUE if the value is not text or blank; FALSE if the value is text.
Remarks
An empty string is considered text.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
The following DAX query shows the behavior of the ISNONTEXT function.
EVALUATE {
IF( ISNONTEXT( 1 ), "Is Non-Text", "Is Text" ), // RETURNS: Is Non-Text
IF( ISNONTEXT( BLANK ( ) ), "Is Non-Text", "Is Text" ), // RETURNS: Is Non-Text
IF( ISNONTEXT( ""), "Is Non-Text", "Is Text" ) // RETURNS: Is Text
}