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

anmolmalviya05's avatar
anmolmalviya05
Super User
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)))