Reply
mdubose
Helper I
Helper I
Partially syndicated - Outbound

How to return the number of rows displayed in a visual

Hello,

 

I've created a report where I'm pulling columns from multiple tables.  These tables have a relationship.  I need to get the number of rows returned from my table visual.  I've tried creating a measure like this: Rows=COUNTROWS('Table A')+COUNTROWS('Table B').  This meaure is returning the number of rows in Table A and Table B in the database, not the number of rows in my visualization.  

 

For example, the measure returns 700 rows.  The number of rows in my visual is 100 rows.

 

How can I return the number of rows displayed in my visual?

 

1 ACCEPTED SOLUTION

Syndicated - Outbound

hi @mdubose 

try like:
Count =
COUNTROWS(
    SUMMARIZE(
       TableA1,
       TableA[Case Number],
       TableA[Name First],
       TableA[Name Middle],
       TableA[Name Last],   
       TableB[Requester First Name],
       TableB[Requester Ladt Name]
)

View solution in original post

9 REPLIES 9
ppm1
Solution Sage
Solution Sage

Syndicated - Outbound

If all of the columns used share a common fact table, you can use an expression like this to get your row count.

 

RowCount = COUNTROWS(SUMMARIZE(FactTable, Dim1[Column1], Dim2[Column2], ...))

 

Pat

Microsoft Employee
FreemanZ
Super User
Super User

Syndicated - Outbound

hi @mdubose 

how does your table visual look like?

Syndicated - Outbound

Below is a sample of my table visual. I want to get the count of rows in this table visual.

 

mdubose_0-1674270939911.png

 

Syndicated - Outbound

hi @mdubose  

which of the fields are columns and which are measure? How does the measure look like?

 

p.s. please consider @someone, if you seek further suggestions. 

Syndicated - Outbound

Hi @FreemanZ ,

All the fields in the sample visual are columns.  I want to put my measure next to the word, "Count".  The DAX formula in the measure is this for example: Rows=COUNTROWS('Table A')+COUNTROWS('Table B').  What's returned from the DAX is 700 because it's counting the rows in Table A which is 500 plus counting the rows in Table B which is 200.  However, this formula doesn't return the actual number of rows displayed in my visual.

Syndicated - Outbound

hi @micheledubose 

which of the columns are from Table A and which are from Table B? How are the two tables related or which table is on the many side?

Syndicated - Outbound

Hi @FreemanZ ,

Below is an example of my table visual without displaying the values. 

 

mdubose_0-1674343471562.png

 

Columns Case Number to Name Last are from Table A.

Columns Requester First Name and Requester Last  Name are from Table B.

Table A is related to a different table called Table A1. Table A is one to many to Table A1. Table A1 is many to one to Table B.

Syndicated - Outbound

hi @mdubose 

try like:
Count =
COUNTROWS(
    SUMMARIZE(
       TableA1,
       TableA[Case Number],
       TableA[Name First],
       TableA[Name Middle],
       TableA[Name Last],   
       TableB[Requester First Name],
       TableB[Requester Ladt Name]
)

Syndicated - Outbound

Hi @FreemanZ ,

 

That worked! Thanks!

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)