Forum Discussion
Summing the values from multiple columns
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.
Sure Baskar see attached screenshot. I guess my post wasn't as self-explanatory as I thought :robotindifferent
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
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...
Anonymous use the same formula to create calculated column, it will resolve your problem.
Anonymous,
You may select Unpivot Columns in Query Editor first.
https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415
