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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

How to display total number on the card visual for records displaying in table visual

Hello all,


I am new to Power bi, need your help to calculate the number of rows coming up in table visual.


I have 2 datasets with many to many relationship. Table visual contains columns from both datasets. Now I am not able to show the total number of records on the card visual.  Can you please help me out, also the total number should get changed as per the slicer.


I have created power bi report with sample data, pls find attached file in below link

Sample pbix 


Thanks in advance.

Super User
Super User

@nitish_sharma , You need to query like


countrows(Summarize(Fact, Dim[Col1], dim[Col2], "_1", [Measure], "_2", [Measure]))

@amitchandak, Thanks for reply.


I have tried this but it dosen't works. I have tried with SUMMARIZECOLUMNS also, but that too didn't worked.



Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors