Forum Discussion
COUNT IF Measure in Query Editor
So I have a column which holds a text string which is populated from a list of options the user can select from. The column holds an error reason. I want to calculate total errors based on this colum...
If you are not aggregating, but just want 0 or 1 flag for each row.
= if [error reason] <> "No Error" then 1 else 0
If you want to count errors. Otherwise, just reverse 0 & 1.
You should use Group by function. And group data based on the column(s), using COUNT as aggregation.
If you don't want the final result to be aggregated, you can join it back to original table.