Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count from different tables

 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 = CALCUL...
Need Help
  • tkrupka's avatar
    tkrupka
    6 years ago

    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
    )

tkrupka's avatar
tkrupka
Resolver II
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

Thanks Billion