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
Raindeer's avatar
Raindeer
Frequent Visitor
8 years ago

I just tried this solution but it only returns 1 for each value. I know there are supposed to be atleast 8 entries per value.  You will notice in the picture that some values appear multiple times.

 

Just to give you a bit of context, I am trying to calculate the number of times an activity takes place within one hour for a given date. Activity ID are unique and only appear once a day everyday. 

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.