Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@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,
You may select Unpivot Columns in Query Editor first.
https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |