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...
MFelix
Super User
Super UserHi 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