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.
Why would you not just use counta?
Client Count = COUNTA('Global Sales and Pipeline Extra'[Client])
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.