Forum Discussion

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 PASSES and 6 FAILS, the new measure would show 12.

I can't seem to get a COUNTX to work but i'm probably not doing it right.

Am I able to sum up a specific text value from multiple columns using DAX?

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

6 Replies

Baskar
Resident Rockstar
7 years ago
Anonymous can you please share some of sample data with expected result.
- Anonymous
  Not applicable
  7 years ago
  Sure Baskar see attached screenshot. I guess my post wasn't as self-explanatory as I thought :robotindifferent
  - Baskar
    Resident Rockstar
    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

Related content