Count number of rows in all tables

[Syndicate_Admin]

Hello

I wanted to see how to create a table that shows the number of rows that contain all the tables in the report.

An example of the new table to be created would be:

NombreTabla	Rows
Table A	65
Table B	30
Table C	18

Thanks a lot!

[Greg_Deckler · Accepted solution]

@Syndicate_Admin 

Table = 
    { 
        ( "Table A", COUNTROWS('Table A') ),
        ( "Table B", COUNTROWS('Table B') ),
        ( "Table C", COUNTROWS('Table C') )
    }

[CNENFRNL · Accepted solution]

Maybe some 3rd party tools do the trick; or resort to Power Query,

let
    Source = 
    let 
        tabs = List.Select(Record.FieldNames(#shared), each Text.Contains(_, "Table ")), 
        rs = List.Transform(tabs, each Table.RowCount(Expression.Evaluate("#""" & _ & """", #shared))) 
    in 
        Table.FromColumns({tabs, rs}, {"Table Name", "Rows"})
in
    Source

[Greg_Deckler · Accepted solution]

@Syndicate_Admin 

Table = 
    { 
        ( "Table A", COUNTROWS('Table A') ),
        ( "Table B", COUNTROWS('Table B') ),
        ( "Table C", COUNTROWS('Table C') )
    }