CALCULATE measure with BLANKS

[ryan_b_fiting]

Hey Community - 

This should be simple but I am not sure what is going on here.  I have a simple measure where I am trying to calculate a count based on two filter criteria.  The 'Assignment' measure is just a COUNTROWS then I am filter based on a Grade being BLANK and a Submission Time not being BLANK.  However, as you can see in my red box below, for some reason it is coulnting assignments with a grade of 0 as ungraded even though my logic in my measure.  I am not sure what is going on here, does anyone know how to fix this?

Thanks in advance for all your help!

Ryan  

[amitchandak · Accepted solution]

@ryan_b_fiting , Use like

isblank(Table[Column]) // return true and false

for not

not(isblank(Table[Column])) // return true and false 

[ryan_b_fiting]

@amitchandak got it to work with your suggestion.

Thank You!

[ryan_b_fiting]

Hey @amitchandak 

I am not sure what you are meaning by this, how would this go into the measure?

Or are you saying to use a calculated column?.