topic Re: Count of Non Blank Cells in DAX Commands and Tips

Count of Non Blank Cells

spandy34 — Tue, 20 Feb 2024 12:52:57 GMT

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

Re: Count of Non Blank Cells

talespin — Tue, 20 Feb 2024 13:01:10 GMT

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])) )

Re: Count of Non Blank Cells

spandy34 — Tue, 20 Feb 2024 13:09:39 GMT

Thats brilliant - thank you so much!