How to show total rows in card visual

[anmolmalviya05]

Hi everyone, I have a table visual and slicers in my report.
I want to include a card visual which will show total number of rows in the table visual

[AnkitaaMishra · Accepted solution]

Hi @anmolmalviya05 , 
You can write below measure to countrows dynamically on the table visual : 

Here, if you change the slicer then the measure will show you related number of rows. 

Let me know if this helps or share more details of your query.

Thanks,

Ankita

[danextian · Accepted solution]

Hi @anmolmalviya05 

If it is a table visual, you will need to write a measure that mimics what happens in a table visual. For example

RowCount = 
VAR _tbl =
    SUMMARIZECOLUMNS (
        'Dates'[Month and Year],
        'Dates'[YYYYMM],
        'Category'[Category],
        'Geo'[Geo],
        "Total_Revenue", [Total Revenue]
    )
RETURN
    COUNTROWS ( _tbl )

[anmolmalviya05 · Accepted solution]

Hi @AnkitaaMishra, Thanks for your response,
It works

[danextian · Accepted solution]

Hi @anmolmalviya05 

If it is a table visual, you will need to write a measure that mimics what happens in a table visual. For example

RowCount = 
VAR _tbl =
    SUMMARIZECOLUMNS (
        'Dates'[Month and Year],
        'Dates'[YYYYMM],
        'Category'[Category],
        'Geo'[Geo],
        "Total_Revenue", [Total Revenue]
    )
RETURN
    COUNTROWS ( _tbl )

[anmolmalviya05 · Accepted solution]

Hi @danextian, Thanks for your response
It works

[AnkitaaMishra · Accepted solution]

Hi @anmolmalviya05 , 
You can write below measure to countrows dynamically on the table visual : 

Here, if you change the slicer then the measure will show you related number of rows. 

Let me know if this helps or share more details of your query.

Thanks,

Ankita

[anmolmalviya05 · Accepted solution]

Hi @AnkitaaMishra, Thanks for your response,
It works

[Holiday]

Hi @anmolmalviya05

1. Create a new measure in your Power BI model: 'Total Rows = COUNTROWS(YourTableName)'.
2. Add a new card visual to your report.
3. Add the 'Total Rows' measure to the card visual.
4. The card will now display the total number of rows in your table, dynamically updating based on slicers.

[anmolmalviya05]

Hi @Holiday,Thanks for your  response,
I tried this but it's not working

[rohit1991]

To show the total rows in a card visual in Power BI:

1. Create a Measure: Use the formula Row Count = COUNTROWS(TableName), replacing TableName with your table's name.
   
   
2. Add a Card Visual: Drag the Row Count measure to the card visual.
   
   
3. Ensure it works with slicers: The measure will automatically update based on slicer selections.
   
   

This will dynamically display the total number of rows in your table visual.

[anmolmalviya05]

Hi @rohit1991, Thanks for your  response,
I tried this but it's not working