Count from different tables

[Anonymous]

 I have 6 tables with Status colum having status A, b c. I want to Count Total with Text String in All tables and below is what i tried but no result . Please help

B - Approved As Noted = CALCULATE(COUNT('MAT Register'[Status])="B",('MET Register'[Status])="B",('MIR Register'[Status])="B",('SD Register'[Status])="B",('Technical Register'[Status])="B",('WIR Register'[Status])="B")+0

[tkrupka]

I think COUNT can only use one column.

Have you tried CALCULATE( COUNT(AAA[xxx]) + COUNT(BBB[yyy]) + COUNT(CCC[zzz]))?

[Anonymous]

But then how i will be able to Count Status "B" only

That will Calculate All Status A,B,C,D

[tkrupka · Accepted solution]

Cleaned it up a bit, but try this.

B - Approved As Noted =
CALCULATE (
CALCULATE ( COUNT ( 'MAT Register'[Status]), 'MAT Register'[Status]="B" ) ) +
CALCULATE ( COUNT ( 'MET Register'[Status]), 'MET Register'[Status]="B" ) ) +
CALCULATE ( COUNT ( 'MIR Register'[Status]), 'MIR Register'[Status]="B" ) ) +
CALCULATE ( COUNT ( 'SD Register'[Status]), 'SD Register'[Status]="B" ) ) +
CALCULATE ( COUNT( 'Technical Register'[Status]), 'Technical Register'[Status]="B" ) ) +
CALCULATE ( COUNT ( 'WIR Register'[Status]), 'WIR Register'[Status]="B" ) ) +
0
)

[Anonymous]

Thanks Billion