- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Display total row count of a matrix visual
Hi All,
I have a matrix visual for which I am extracting a rows, columns and values from an pivot table. I have take employee id as the reference and unpivotted all the other columns and thus left with 3 columns - employee_id, attribute and value.
Now, how do I write a dax expression such that it gives me the correct row count dynamically based on slicer selections.
The function which I wrote is
Row Count = COUNTROWS(SUMMARIZECOLUMNS(Table_Name[ColumnName]))
But it is not giving the right results when I compare the data in Power BI with that of the database.
Please suggest how to go about this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous
Can you provide some sample data? Which column is used in the slicer for different selections? What do you want to count rows on? Currently you have employee_id, attribute and value, so which is the ColumnName column used in the current measure? The expected result is not very clear to me so it's difficult to provide a detailed suggestion or solution.
Best Regards,
Community Support Team _ Jing

Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

User | Count |
---|---|
71 | |
69 | |
38 | |
26 | |
26 |
User | Count |
---|---|
97 | |
96 | |
59 | |
44 | |
40 |