https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-COUNTROWS-for-all-Tables/m-p/2182101#M50806 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="92006" data-lia-user-login="joshua1990" class="lia-mention lia-mention-user">joshua1990</a>&nbsp;I'm not aware of a way to do that other than:</P> <LI-CODE lang="markup">Measure = VAR __Table1 = COUNTROWS('Table1') VAR __Table2 = COUNTROWS('Table2') VAR __Table3 = COUNTROWS('Table3') RETURN __Table1 + __Table2 + __Table3</LI-CODE> <P>Another possibility would be to use DMV's which are at the heart of the Vertipaq Analyzer might be a path to victory.&nbsp;<A href="https://docs.microsoft.com/en-us/openspecs/sql_server_protocols/ms-ssas/eae69b5d-bd76-42d2-8429-665bf08d2cf0" target="_blank">[MS-SSAS]: DISCOVER_STORAGE_TABLES | Microsoft Docs</A></P> Wed, 10 Nov 2021 07:36:56 GMT Greg_Deckler 2021-11-10T07:36:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-COUNTROWS-for-all-Tables/m-p/2182052#M50805 <P>Hello everyone!</P><P>I have a PBI File where I am connected to 50 tables.</P><P>Now I would like to get the number of rows for all tables at once without creating a measure for each table.</P><P>Is this possible within PBI or by using DAX Studio or Tabular Editor?</P> Wed, 10 Nov 2021 07:12:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-COUNTROWS-for-all-Tables/m-p/2182052#M50805 joshua1990 2021-11-10T07:12:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-COUNTROWS-for-all-Tables/m-p/2182101#M50806 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="92006" data-lia-user-login="joshua1990" class="lia-mention lia-mention-user">joshua1990</a>&nbsp;I'm not aware of a way to do that other than:</P> <LI-CODE lang="markup">Measure = VAR __Table1 = COUNTROWS('Table1') VAR __Table2 = COUNTROWS('Table2') VAR __Table3 = COUNTROWS('Table3') RETURN __Table1 + __Table2 + __Table3</LI-CODE> <P>Another possibility would be to use DMV's which are at the heart of the Vertipaq Analyzer might be a path to victory.&nbsp;<A href="https://docs.microsoft.com/en-us/openspecs/sql_server_protocols/ms-ssas/eae69b5d-bd76-42d2-8429-665bf08d2cf0" target="_blank">[MS-SSAS]: DISCOVER_STORAGE_TABLES | Microsoft Docs</A></P> Wed, 10 Nov 2021 07:36:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-COUNTROWS-for-all-Tables/m-p/2182101#M50806 Greg_Deckler 2021-11-10T07:36:56Z