Count Rows in Multiple Related table - Calculated column

[kvnmny]

Hello, I am attempting to count the total number of rows in a series of related tables.  How would I go about creating a calculated column that would calculate the total number of rows in each related table.

E.G. I would like to know how many rows is in each ORDER_DETAILS table.

[v-sihou-msft · Accepted solution]

@kvnmny

You can directly add a custom column using Table.RowCount() function to get the row count of each table.

Regards,

[vanessafvg]

You would probably have to do a count on them separately and then merge them back with the table you wanting to store the information in.