DAX Help

[niyatisheth]

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

[anmolmalviya05 · Accepted solution]

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 · Accepted solution]

@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]

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.

[anmolmalviya05 · Accepted solution]

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)))

[FBergamaschi]

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

[rohit1991]

Hii @niyatisheth 

To show the number of rows in your table visual dynamically, create this simple measure:

Row Count =
COUNTROWS(VALUES(YourTable[PrimaryKeyColumn]))