Forum Discussion

niyatisheth's avatar
niyatisheth
New Member
8 months ago
Solved

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 update...
  • anmolmalviya05's avatar
    anmolmalviya05
    8 months ago

    Hi niyatisheth,

    Can you please try the below measure, I used it in few of my reports

    Countrows_15min =
     var a=
        SUMMARIZE ('Contact Record',
            'Calendar Table'[DateTime],'Calendar Table'[Time],
            "tc",[Total Calls]
        )
    RETURN
    CONCATENATE("Total Row Count: ",(COUNTROWS(a)))
  • Kedar_Pande's avatar
    Kedar_Pande
    8 months ago

    niyatisheth 

     

    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

Ahmed-Elfeel's avatar
Ahmed-Elfeel
Super User
8 months ago

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.