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
Super 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
    Super 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

    • Raindeer's avatar
      Raindeer
      Frequent Visitor
      8 years ago

      Hi MFelix,

       

      Thank you for your prompt reply.

       

      I just tried CountA but its still not working. I am still seeing same result as my earlier screenshots. 

       

      Do you think it could be becuase of some bug in Power BI?

       

      Kind Regards

       

      Raindeer

      • MFelix's avatar
        MFelix
        Super User
        8 years ago

        Hi Raindeer,

         

        You should make a measure not a calculated column. The use of the measure will allow you to add context to your visuals and change the calculations only by adding or removing columns from your visuals.

         

        Regards,

        MFelix