Forum Discussion
Solved
Countrows Function
Hi...I am not sure I what I about to say correctly so please forgive me. I am trying to count rows in a table and have the filters that have applied to the table outside applied. When I use the C...
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.
