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
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
Solved! Go to 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])) )
Thats brilliant - thank you so much!
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])) )
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
16 | |
11 | |
10 | |
8 |
User | Count |
---|---|
62 | |
20 | |
11 | |
11 | |
11 |