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
inglexjc's avatar
inglexjc
Post Patron
3 years ago

Table looks like this:

I have Measure to high light "Letter Wavied" in blue:

Measure 4 = IF(CONTAINSSTRING(SELECTEDVALUE('Legal Files'[Description_1]),"Letter Waived"),"blue","black")
 
And Measure to make date for Letter Due to Supervisor to be blank:
Letter Due to Supervisor Measure = IF(CONTAINSSTRING(MAX('Legal Files'[Description_1]), "Letter Waived")," ", MAX('Legal Files'[Letter Due to Supervisor]))
 
I need the count to correctly count how many rows have a Date in the Letter Due to Supervisor.
 
Does this help?