Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have about 38 tables that I need to get rowcounts for and display the row count for each table. Unfortunately the COUNTROWS function seems to need me to specify the table name that I want a count for. Creating 38 separate COUNTROW measures doesn't seem to let me visualize the list in the right way either.
I want the visual to look something like this.
Table name | Row Count |
A | 1000 |
B | 20000 |
C | 3000 |
D | 40000000 |
I have a table that has all the table names in them that could be used as a fact table. And there's the other 38 tables I need the row counts from.
Solved! Go to Solution.
Hi @Anonymous ,
You can create a new table with the table names and then create measure to calculate the number of rows in each table.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can create a new table with the table names and then create measure to calculate the number of rows in each table.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Why don't you append those tables in one ?
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data#combine-queries
Ricardo
@camargos88 will that be an issue with 38 fairly large tables?
But let's say I can append all the tables, then what?
Would I need to create a new column on each table with the table name first before appending? I need the row counts of multiple tables rather than the row count of a single large table.
Directquery with a SQL Database
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |