Forum Discussion
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...
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 can you please share some of sample data with expected result.