Countrows Function

[hkrash0920]

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 Count function where all the fields are listed, I get the correct number.

However, I want to change the name of the column from "count of client" to something else and you can't do that so I was trying to create an expression to get the same output but have been unsuccessful.

My expression is:

Client Count = COUNTROWS(ALLSELECTED('Global Sales and Pipeline Extra'[Client]))

Any help is appreciated.

Thanks

[Anonymous]

Why would you not just use counta?

Client Count = COUNTA('Global Sales and Pipeline Extra'[Client])

[hkrash0920]

The outcome is not right. I am assuming it is counting all the text characters in each cell. The column is all text. Thanks. 

[Anonymous]

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.

[hkrash0920]

Here is a screenshot of it. Does this help? Count of client is correct.

[Anonymous · Accepted solution]

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.

[kcantor]

@hkrash0920

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.

[hkrash0920]

Counta as a measure worked. When I did it as a new column, it didn't. Thank you...thank you...thank you.