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.
Hi Chihiro,
Cool name btw. Like from the Ghibli film Spirited Away.
I wanted it to be a new column which I created in Query Editor therefore not using DAX. So a column which would hold a 1 or a 0 for each row of data based on the value in the column [error reason].
So you're right, not a measure, just a new column. Are you able to suggest the M code for an equivalent COUNTIF function?
Thanks! :-)
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.