Forum Discussion
Solved
How do I count rows and exclude certain text?
I see lots of answers on how to count rows containing certain text, but I need to count rows of text that do not contain the word "Open". How do I do this?
Yes! That worked! Thank you SO much! Been struggling all morning on that. I am a relatively new user.
I just sent you the FILTER (which you need to use inside CALCULATE).
Create a new measure like this :
YourMeasure = CALCULATE( COUNT('YourTable'[YourColumn]),FILTER('YourTable', NOT(CONTAINSSTRING('YourTable'[YourColumn], "Open")))
Have a nice day.
Yes! That worked! Thank you SO much! Been struggling all morning on that. I am a relatively new user.
Glad it is working well 🙂