Counting Text Values in Multiple Columns and Tables

[NB3]

Hi everyone,

I'm trying to count the total number of merchants in different tables.

Basicaly I tried the following formula 😕

Total = CALCULATE(COUNT('US Partners_AB'[Merchant])

But I don't know how to add column names from other tables to make this work ? (I get an error as soon as I try to use the measure with 2 or more column names)

Thanks,

[dedelman_clng · Accepted solution]

Do separate counts with + in between

Total = COUNT(Table1[Merchant]) + COUNT(Table2[Merchant]) + COUNT(Table3[Merchant]) + ...

Hope this helps

David