Forum Discussion

inglexjc's avatar
inglexjc
Post Patron
3 years ago

Count rows based on data from a Measure

I have a measure so that my Column in my table "Letter Due to Supervisor" shows up blank/no date if in the Descritpion shows "Letter Wavied".  Trying to get an accurate count of how many rows do have...
Need Help
themistoklis's avatar
themistoklis
Community Champion
3 years ago

inglexjc 

 

Why are you trying to use the column with dates and not the description column:

 

Try measure below:

Measure = COUNTROWS(FILTER(Sheet1, Not(CONTAINSSTRING(Sheet1[Description], "Letter Waived"))))
inglexjc's avatar
inglexjc
Post Patron
3 years ago

I can have it count the Description as long as it doesn't count where it says "Letter Waived"

Using:

Measure = COUNTROWS(FILTER('Legal Files', Not(CONTAINSSTRING('Legal Files'[Description_1], "Letter Waived"))))  It's counting 995 it should only be 63.  So it looks like it's not counting the row.