Forum Discussion

jr3151006's avatar
jr3151006
Icon for Helper IV rankHelper IV
4 years ago
Solved

How to count (sum) records from different Tables?

Hi,   we have a situation with an Excel file which has 03 spreadsheets inside. When we open it via PBI, we select all of these 03. The We need show on some page, the count of all records from spre...
Show and Tell
  • TheoC's avatar
    TheoC
    4 years ago

    Hi jr3151006 

     

    You can use something like the following:

     

    Measure = 

    VAR _1 = COUNTROWS ( 'TableA' )
    VAR _2 = COUNTROWS ( 'TableB' )
    VAR _3 = COUNTROWS ( 'TableC' )

    RETURN
    _1 + _2 + _3

     

    Hope this helps 🙂

    Theo

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

jr3151006 If all those 3 sheets have same structure so combine them by creating a new table using UNION function.

New Table = UNION(Sheet1,Sheet2,Sheet3)

 

jr3151006's avatar
jr3151006
Icon for Helper IV rankHelper IV
4 years ago

Tks Tahreem24,

 

but the tables structure are not the same.

 

I was able to test with success the 'Teoc' advice.

 

tks for all!