Forum Discussion
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...
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.
