Forum Discussion

amateu's avatar
amateu
Frequent Visitor
7 years ago
Solved

COUNT GROUPED IN EACH ROWS

Hello,   I would add summary colums to the table (N_PASS and N_FAIL). There is an example in the data file. These colums are the count of the status grouped by SERIAL_NUMBER and OPERATION.   I ca...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, amateu 

    Just use these two formulae to create two columns:

    new N_PASS = CALCULATE(COUNTA('Table'[STATUS]),FILTER(ALLEXCEPT('Table','Table'[OPERATION],'Table'[SERIAL NUMBER ]),'Table'[STATUS]="PASS"))+0
    new N_FAIL = CALCULATE(COUNTA('Table'[STATUS]),FILTER(ALLEXCEPT('Table','Table'[OPERATION],'Table'[SERIAL NUMBER ]),'Table'[STATUS]="FAIL"))+0

    Result:

     

    Best Regards,

    Lin

     

     

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

HI, amateu 

Just use these two formulae to create two columns:

new N_PASS = CALCULATE(COUNTA('Table'[STATUS]),FILTER(ALLEXCEPT('Table','Table'[OPERATION],'Table'[SERIAL NUMBER ]),'Table'[STATUS]="PASS"))+0
new N_FAIL = CALCULATE(COUNTA('Table'[STATUS]),FILTER(ALLEXCEPT('Table','Table'[OPERATION],'Table'[SERIAL NUMBER ]),'Table'[STATUS]="FAIL"))+0

Result:

 

Best Regards,

Lin