Forum Discussion
DAX Help
Hi Everyone, I have a table visual and I want to show the number of rows within that visual in a card, I want it to be dynamic such that whenever a filter get applied then the number should be updated. Any help will be much appreciated
Hi niyatisheth,
Can you please try the below measure, I used it in few of my reportsCountrows_15min =var a=SUMMARIZE ('Contact Record','Calendar Table'[DateTime],'Calendar Table'[Time],"tc",[Total Calls])RETURNCONCATENATE("Total Row Count: ",(COUNTROWS(a)))Table Row Count = COUNTROWS('YourTableName')
If table has multiple tables joined:
Table Row Count = COUNTROWS(SUMMARIZE('MainTable', 'MainTable'[KeyColumn]))
If this answer helped, please click Kudos or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande
5 Replies
Hii niyatisheth
To show the number of rows in your table visual dynamically, create this simple measure:
Row Count = COUNTROWS(VALUES(YourTable[PrimaryKeyColumn]))Create a measure with this DAX code
COUNTROWS ( YourTable )
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi niyatisheth,
Can you please try the below measure, I used it in few of my reportsCountrows_15min =var a=SUMMARIZE ('Contact Record','Calendar Table'[DateTime],'Calendar Table'[Time],"tc",[Total Calls])RETURNCONCATENATE("Total Row Count: ",(COUNTROWS(a)))Hi niyatisheth,
I hope you are doing well today ☺️❤️
So basically to show a dynamic count of rows in a table visual that updates with filters create this measure:
Row Count = COUNTROWS('YourTableName')- Replace YourTableName with your actual table name
- Add this measure to a card visual
- It will automatically update when you apply filters
Bonus Approach: (if you need to count only visible columns)
Row Count = COUNTROWS(ALLSELECTED('YourTableName'))if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.Table Row Count = COUNTROWS('YourTableName')
If table has multiple tables joined:
Table Row Count = COUNTROWS(SUMMARIZE('MainTable', 'MainTable'[KeyColumn]))
If this answer helped, please click Kudos or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande
