topic Re: Count Rows of a Visual Table in DAX Commands and Tips

Count Rows of a Visual Table

barragan82 — Wed, 09 Jul 2025 21:41:05 GMT

Hi all,

In the example below, I am trying to create a measure that counts the number of rows of this specific visual table, not of the rows of data in the table "behind the scenes." Specifically, I am trying to identify/count that we have a total of eight (8) for the EMAIL ADDRESS column. DISTINCTCOUNT gives me a result of 2 while COUNTROWS gives me a result of 11. I would appreciate any ideas. Thank you!

Re: Count Rows of a Visual Table

AlexisOlson — Wed, 09 Jul 2025 22:05:06 GMT

It looks like the number of rows is determined by unique combinations of EMAIL ADDRESS, ARTIFACT SUBMISSION, and COURSE.

Assuming these are all columns of a single table named Table1, I'd expect something like this to work:

COUNTROWS ( SUMMARIZECOLUMNS ( Table1[EMAIL ADDRESS], Table1[ARTIFACT SUBMISSION], Table1[COURSE] ) )

Re: Count Rows of a Visual Table

v-saisrao-msft — Thu, 10 Jul 2025 05:18:24 GMT

Hi barragan82,

Thank you for reaching out to the Microsoft fabric community forum. Thank you AlexisOlson for your input on this issue.

After reviewing the details you provided, I was able to reproduce the scenario, I have used it as sample data on my end and implemented it.

Dax Measure:

Row Visual Count = IF( ISINSCOPE('Instructors'[EMAIL ADDRESS]) && ISINSCOPE('Instructors'[COURSE]), 1, COUNTROWS( SUMMARIZE( 'Instructors', 'Instructors'[EMAIL ADDRESS], 'Instructors'[COURSE] ) ) )

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

Re: Count Rows of a Visual Table

barragan82 — Thu, 10 Jul 2025 13:17:26 GMT

Thank you, this did exactly what I wanted it to.

Re: Count Rows of a Visual Table

barragan82 — Thu, 10 Jul 2025 13:18:43 GMT

That did exactly what I needed. Thank you.

Re: Count Rows of a Visual Table

aleksvp — Sat, 13 Sep 2025 13:02:43 GMT

There is a solution for that using Python Visual. It is a solution that fits even if you use field parameters in your table.
https://www.simpledev.tech/post/how-to-display-the-number-of-rows-in-a-power-bi-table-visual

Re: Count Rows of a Visual Table

BonnieW — Tue, 28 Oct 2025 16:50:32 GMT

If you are asking what I think you are asking, there might be a simpler solution for you.
The short version is create a measure like this and add it to your table:
RowsDisplayed_TotalOnly = IF(ISINSCOPE('DataTableName'[PrimaryKeyFieldName]), " ", COUNTROWS(ALLSELECTED('DataTableName')))

For more details on usage and why it works, see my recent comment on Solved: How to display the count of the rows in a table vi... - Microsoft Fabric Community.

Re: Count Rows of a Visual Table

barragan82 — Thu, 06 Nov 2025 16:11:54 GMT

Thank you, BonnieW! I'll keep this in mind the next time I need this function.