Forum Discussion

NB3's avatar
NB3
Helper III
7 years ago
Solved

Counting Text Values in Multiple Columns and Tables

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,
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    Do separate counts with + in between

     

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

    Hope this helps

    David

1 Reply

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    7 years ago

    Do separate counts with + in between

     

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

    Hope this helps

    David