Forum Discussion

jochendecraene's avatar
jochendecraene
Icon for Helper V rankHelper V
4 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
    4 years ago

    jochendecraene 

    Measure 3 = 
    VAR __Table = ADDCOLUMNS('Table4',"__IsNotInt",ISERROR(INT([Column1])))
RETURN
    COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__Table,[__IsNotInt]=FALSE()),"Int",[Column1])))
jochendecraene's avatar
jochendecraene
Icon for Helper V rankHelper V
4 years ago

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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

jochendecraene 

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