Return a 1 if column has text in it using DAX

[brockry1]

How do I add another column that will bring back a value of "1" if the ID column contains text. 

[Greg_Deckler · Accepted solution]

@brockry1 Here is one way. PBIX attached below signature.

Column = 
    VAR __Len = LEN( [Id] )
    VAR __Table = 
        ADDCOLUMNS(
            ADDCOLUMNS(
                ADDCOLUMNS(
                    GENERATESERIES( 1, __Len, 1 ),
                    "__Char", MID( [Id], [Value], 1 )
                ),
                "__Unicode", UNICODE( [__Char] )
            ),
            "__IsText", 
                IF(  
                    ( [__Unicode] >= 65 && [__Unicode] <= 90 ) ||
                    ( [__Unicode] >= 97 && [__Unicode] <= 122 ),
                    1, 0
                )
        )
    VAR __Result = IF( COUNTROWS( FILTER( __Table, [__IsText] = 1 ) ) > 0, 1, 0 )
RETURN
    __Result

[Fowmy]

@brockry1 

Not sure if I got your question.

Add a calculated column : 

INT( NOT ISBLANK(Tablename[ID]) && ISTEXT(Tablename[ID]) )