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.
  • themistoklis's avatar
    themistoklis
    Community Champion
    3 years ago

    can you share the full dataset with us... if it doesnt contain any sensitive data

    IM saying this because it works on the sample dataset you sent

     

    Also in you formula you use a field called Description_1 ... in your message the field is Description (with the _1)

    • inglexjc's avatar
      inglexjc
      Post Patron
      3 years ago

      The information has PPI so I can not share it.  But those are the columns that I need help with.