Forum Discussion
Countrows Function
And how have you written Client Count for that screenshot? COUNTA should give the same results as the count quick measure unless you've added something else.
The outcome is not right. I am assuming it is counting all the text characters in each cell. The column is all text. Thanks.
No, it's counting each non-blank row in the column given the filter context, including duplicate values. Maybe you want DISTINCTCOUNT? It's unclear how your data is structured or how exactly the incorrect results are incorrect.
Here is a screenshot of it. Does this help? Count of client is correct.
And how have you written Client Count for that screenshot? COUNTA should give the same results as the count quick measure unless you've added something else.
Check to see which count is automating by clicking the drop down arrow by the name in your fields. Then create a measure to match. See image.
