Forum Discussion

jochendecraene's avatar
jochendecraene
Helper 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])))
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

jochendecraene Maybe:

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

    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's avatar
      Greg_Deckler
      Community Champion
      4 years ago
      Measure 3 = 
    VAR __Table = ADDCOLUMNS('Table4',"__IsNotInt",ISERROR(INT([Column1])))
RETURN
    COUNTROWS(DISTINCT(FILTER(__Table,[__IsNotInt]=FALSE())))
      • jochendecraene's avatar
        jochendecraene
        Helper 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 ...