Forum Discussion

jochendecraene's avatar
jochendecraene
Icon for Helper V rankHelper V
5 years ago
Solved

Count cell that contain integers

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 t...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    jochendecraene 

    Measure 3 = 
    VAR __Table = ADDCOLUMNS('Table4',"__IsNotInt",ISERROR(INT([Column1])))
RETURN
    COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__Table,[__IsNotInt]=FALSE()),"Int",[Column1])))
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

jochendecraene 

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