sum words in multiple tables, how to?

[pipignu]

Hello,

I need to sum words from different tables. Example:

TABLE1
Column Name

FCO

FCO

FCO

MSE

MSE

TABLE2

Column Name

MCA

MCA

FCO

MSE

I need to obtain this result: Total: 9. FCO=4, MSE=3, MCA=2.

Could you help me please?

Thanks

[Ashish_Mathur]

Hi,

Using Query Editor, you can append data from both tables into a single one and then write this measure.

=COUNTROWS(Data[Names])

Hope this helps.

[v-ljerr-msft · Accepted solution]

Hi @pipignu,

Based on my test, you can firstly use the formula below to create a new union table.

Table =
UNION (
    SELECTCOLUMNS ( Table1, "NewColumn", Table1[Column Name] ),
    SELECTCOLUMNS ( Table2, "NewColumn", Table2[Column Name] )
)

Then you should be able to show the "NewColumn" and [Count of NewColumn] from the new created table on the Table visual to get your expected result. 

Regards