Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
spandy34
Responsive Resident
Responsive Resident

Count of Non Blank Cells

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
spandy34_0-1708433304655.png

 

1 ACCEPTED SOLUTION
talespin
Solution Sage
Solution Sage

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

View solution in original post

2 REPLIES 2
spandy34
Responsive Resident
Responsive Resident

Thats brilliant - thank you so much!

talespin
Solution Sage
Solution Sage

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.