Column cleaning with DAX

[Anonymous]

Hi guys, 

Can you please help me with column cleaning.  It has two data types ( int and text) and some blanks.  I just want to keep them  integers.  Can you please help me writing Dax Querry. 

Many Thanks, C

Column A
12
10
20
A
B
C
50

[smpa01 · Accepted solution]

@Anonymous  you can write a measure like this

Measure =
CALCULATE (
    MAX ( 'Table 1'[Column A] ),
    FILTER (
        'Table 1',
        IFERROR ( CONVERT ( 'Table 1'[Column A], INTEGER ), -999 )
            = IFERROR ( 'Table 1'[Column A] * 1, 0 )
    )
)

[smpa01]

@Anonymous  did you have a chance to look into the solution I provided?