Count cell that contain integers

[jochendecraene]

Hi

I've got a colum that contains text and integers. I'd like to know home many unique codes (integers) there are in my dataset.

Can someone help me out? So I only want to count the cells with the integers in the example.

[Greg_Deckler]

@jochendecraene Maybe:

Measure 3 = 
    VAR __Table = ADDCOLUMNS('Table4',"__IsNotInt",ISERROR(INT([Column1])))
RETURN
    COUNTROWS(FILTER(__Table,[__IsNotInt]=FALSE()))

[jochendecraene]

@Greg_Deckler 

Thanks for the quick response.

This gives me the number of cells containing integers. But can I have a distinct count of the codes?

[Greg_Deckler]

Measure 3 = 
    VAR __Table = ADDCOLUMNS('Table4',"__IsNotInt",ISERROR(INT([Column1])))
RETURN
    COUNTROWS(DISTINCT(FILTER(__Table,[__IsNotInt]=FALSE())))

[jochendecraene]

@Greg_Deckler 

that is giving me the same count as without the 'dsitcint' ...  I made a test column with 291 times the same code. The two measures return 291 as result. I've expected the new measure to return 1 ...

[Greg_Deckler · Accepted solution]

@jochendecraene 

Measure 3 = 
    VAR __Table = ADDCOLUMNS('Table4',"__IsNotInt",ISERROR(INT([Column1])))
RETURN
    COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__Table,[__IsNotInt]=FALSE()),"Int",[Column1])))

[jochendecraene]

@Greg_Deckler 

Thank you sir for your help. This workes 🙂