Forum Discussion

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

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

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

tkrupka's avatar
tkrupka
Icon for Resolver II rankResolver II
7 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
    7 years ago

    Thanks Billion