Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mdubose
Helper I
Helper I

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

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

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

hi @mdubose 

how does your table visual look like?

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

 

mdubose_0-1674270939911.png

 

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. 

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.

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?

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.

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]
)

Hi @FreemanZ ,

 

That worked! Thanks!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.