Forum Discussion
COMtrac
9 years agoAdvocate I
Adding a row count to a visual table
I was wondering whether there is an easy way to add a count to a column in a visual table in PowerBI Desktop. The column in the table has text entries and basically I just want to show the total of ...
PowerMic
3 years agoNew Member
So Sorry to revive an old post, but this was the first option on google, so I'm sure other poeple will land here.
If you add any column to the table, choose "Count Distinct" as the aggregate function, then rename the column to something short like ".". I then format that specific column to have values/header the same colour as my background. It's not perfect, but it works, and it doesn't really add too much to the visual.