Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summing the values from multiple columns

Hello,   I have several columns of data which old a 'PASS' 'FAIL' or 'N/A' value.   I need to count per row the total 'PASS' values within all the columns. So for example if Row A contained 12...
Need Help
  • Baskar's avatar
    Baskar
    7 years ago

    Anonymous

     

    Here we have to create measure for each column. 

     

    Pass Count = 

     calculate(counta( TableName(Column1)), TableName(Column1)="Pass") +

     calculate(counta( TableName(Column2)), TableName(Column2)="Pass") +

     calculate(counta( TableName(Column3)), TableName(Column3)="Pass") +

     calculate(counta( TableName(Column4)), TableName(Column4)="Pass") +

     calculate(counta( TableName(Column5)), TableName(Column5)="Pass") 

     

     

     

    Note :

    Replace Tablename and column name 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sure Baskar see attached screenshot. I guess my post wasn't as self-explanatory as I thought :robotindifferent