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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Malsha
Helper I
Helper I

Get records count of a created table visual.

Hi everyone,
I created an table visual in my power bi report by adding different columns in different table in my data model. Is there a way to show the record count of that created table visual in the report?

Please help me to get the record count of created table and show it in the report page as well. Really appreciate your help in this matter.

Thank you.

2 REPLIES 2
amitchandak
Super User
Super User

@Malsha , Create a measure like this with all the columns of table visual 

 

countrows(Summarize(Fact, Dim[Col1], Dim2[Col2], "_1",[Mes1], "_2",[Mes2]))

 

Not summarized Columns as a group by of summarize and measures with new names

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi amitchandak,
Thank you for your support.

I am adding different columns from the different tables to my visual. So could you explain in your measure that you have mentioned above (countrows(Summarize(Fact, Dim[Col1], Dim2[Col2], "_1",[Mes1], "_2",[Mes2]))) what should I take as the 'Fact'. and is this working when data filters using filterations in the report. I mean is it give the correct row count that time as well.

or can we get the table visual row count by considering one column of it?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors