Count of Non Blank Cells

[spandy34]

I have a table that includes an Email field and a field called Activated.  I need to calculate the number of distinct email addresses where the field name Activated is not blank (has a date in)

 I have tried 

Total Activated = CALCULATE(DISTINCTCOUNT('Stay Safe Usage Reports'[Email Address]),'Stay Safe Usage Reports'[Activated]<>"")

but i get the following message .  Please can someone help.

Thank you 

 @amitchandak

@tamerj1 @danextian @goncalogeraldes 

[spandy34]

Thats brilliant - thank you so much!

[talespin · Accepted solution]

Hi @spandy34 

You can't compare Date data type with string. Please try this.

Total Activated = CALCULATE(DISTINCTCOUNT('Stay Safe Usage Reports'[Email Address]), NOT(ISBLANK('Stay Safe Usage Reports'[Activated])) )