How does the ISTEXT function (DAX) work?

ISTEXT function (DAX) checks for text and returns either TRUE or FALSE.

ISTEXT Formula Syntax

ISTEXT (<value>)

How do you use the ISTEXT function?

This function checks whether a value is text, and returns either TRUE or FALSE.

Considerations when using the ISTEXT function

Empty strings are considered as text.

Blank cells, BLANK () are considered as non-text.

Formula examples using the ISTEXT function

//RETURNS: Is Text  
=IF(ISTEXT("text"), "Is Text", "Is Non-Text")  
  
//RETURNS: Is Text  
=IF(ISTEXT(""), "Is Text", "Is Non-Text")  
  
//RETURNS: Is Non-Text  
=IF(ISTEXT(1), "Is Text", "Is Non-Text")  
  
//RETURNS: Is Non-Text  
=IF(ISTEXT(BLANK()), "Is Text", "Is Non-Text")