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...
Hi Raindeer,
If you add the Values to a table and then add it again and select Count it will give you the expected result.
If you want measure you need to do something like:
Count = COUNT ( TABLE[Column])
The measures are calculated based on the context so if you have a value as a row context it will make a filter of the count based on that row.
Regards,
MFelix
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.
