Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Proud to be a Super User!
Why would you not just use counta?
Client Count = COUNTA('Global Sales and Pipeline Extra'[Client])
Proud to be a Super User!
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.
Proud to be a Super User!
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.
Proud to be a Super User!
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.
Proud to be a Super User!
Counta as a measure worked. When I did it as a new column, it didn't. Thank you...thank you...thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |