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 = 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
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
    )

4 Replies

  • tkrupka's avatar
    tkrupka
    Resolver II
    6 years ago

    I think COUNT can only use one column.

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 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
        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
        )