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

What forumla did you use to get the count?

bolfri's avatar
bolfri
Solution Sage
3 years ago

Create 2 columns:

LetterWaived Flag = IF(CONTAINSSTRING('Sample'[Description_1];"Letter Waived");1;0)
LetterWaived Flag Mark =
var division = [Division]
return SUMX(FILTER('Sample';'Sample'[Division]=division);'Sample'[LetterWaived Flag])
Then the measure is:
Count of rows affeted by Letter Waived = SUM('Sample'[LetterWaived Flag Mark])
 
You just need to change a logic to not affected.
 
And for the description I think you have wrong formula, because max for strings correspondes to a sentence that has later letter in  aphabet. Let me show you difference:
 

 

  • inglexjc's avatar
    inglexjc
    Post Patron
    3 years ago

    What am I doing wrong?  I created a new column and get this error.

     

     

    • bolfri's avatar
      bolfri
      Solution Sage
      3 years ago

      I am using Polish language in DAX, so for me separator is ; 

      Change all ; to , and it will be working. 🙂

      • inglexjc's avatar
        inglexjc
        Post Patron
        3 years ago

        That helped but the count is still wrong.  It's coming up with 83 and it should be 63