Adding count to a table

Question

Hello, please could you advise if there is a way to display the count of records in a table. The data that is being displayed is just text with names and addresses. I can add another column as PersonID and mark it as a Count(distinct). But this displays 1 for every row . It gives me the answer but it will not be accepted by the client due to that column.

Is there a way to hide that column or any other way to display a count.

fowmy · Answer

PBI5851&nbsp;New Column  = COUNTROWS(TABLE)________________________If my answer was helpful, please consider Accept it as the solution to help the other members find itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn&nbsp;

pbi5851 · Answer

Fowmy&nbsp;. Thank you for the reply. But unfortunately, that is adding a column. I want to display the count without adding a new column.&nbsp;

fowmy · Answer

PBI5851&nbsp;Add this as a measureNew Measure =

Calculate ( Countrows(Table), All(Table))________________________If my answer was helpful, please consider Accept it as the solution to help the other members find itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn&nbsp;

v-lili6-msft · Answer

hi&nbsp;&nbsp;PBI5851&nbsp;
if you&nbsp;want to display the count without adding a new column, there two ways for refer to;
1. Create a&nbsp;dynamic title in the table visual to show it.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles
https://medium.com/@patilpoojaif/dynamic-title-in-power-bi-164903723c68
&nbsp;
&nbsp;
2. add a count measure then drag it into card visual and put it beside the table visual.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-card
&nbsp;
&nbsp;

Forum Discussion

Adding count to a table

4 Replies

Related content

Counting nulls

How to get Count from two different table- Un-match Count Table Record with New Table

Adding columns

Table visual rows count

How to Count from two different table Un-matched record with New table