Forum Discussion

Raindeer's avatar
Raindeer
Frequent Visitor
8 years ago

Countif for row based count (A:A=A2)

Hi All,   I have spend over 4 hours n trying to find answer for following but it looks like no one has asked this specific question so far.   I have 100k repeated values in column A and I h...
Need Help
Show and Tell
Tips and Tricks
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi Raindeer,

 

Are you making a Count or a Count distintc? 

 

Regards,

MFelix

Raindeer's avatar
Raindeer
Frequent Visitor
8 years ago

I am counting the number of times same value appears entier column so I suppose its count.

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 years ago

    Raindeer,

     

    Check it on table visual at column level if you have the correct selection:

     

    Regards,

    MFelix

    • Raindeer's avatar
      Raindeer
      Frequent Visitor
      8 years ago

      I need the count in column because I am going to use the values in a later calculation.

       

      I just encountered a weird issue. You original suggestion works perfectly when wrapped in calculate.

       

       

      Calculate(Count(Table[column]))

      But it only works on strings when there are no dates in other columns. Have a look at following two screenshots. 

       

       

      Second screenshot has same formula but different result. 

       

       

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        8 years ago

        Hi Raindeer,

         

        Try to do a COUNTA instead of COUNT without calculate, as in Excel Count is for numbers, COUNTA is for text.

         

        Sorry for misleading you.

         

        Regards

        MFelix