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

Thanks Baskar, it looks like this is summing columns, rather than rows? Each row in my dataset is an audit result,

So I actually don't care about the column totals at all, just the row totals. 

Therefore I figured I would have to create a new calculated column either in DAX or M to achieve this...

Baskar's avatar
Baskar
Resident Rockstar
7 years ago

Anonymous use the same formula to create calculated column, it will resolve your problem.