Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have the figures below which I just did distinct count for customers who registered with email and for customers without email, which I filter this using the filter pane on each visual.
I need thios value to be dinamic to whicheve date I chose on the date filter.
I tried to create a measure diving the numbers os email with '@' by the numbers of emails without the '@', of course using the distinct count. Unfortuantely, I'm not sure what dax to use here. If could help me that would soo helpful.
This is what I have on the table.
Many thanks,
Renata
Solved! Go to Solution.
Hi, thanks for your reply.
Given that the 'email' field doesn't have blank value, I used the measure below.
Email Registration = calculate(distinctcount('Zendesk Customer History'[Email]),
filter('Zendesk Customer History',
CONTAINSSTRING('Zendesk Customer History'[Email],"@")))
@RenataOGardner , Try measures like
without email =
calculate(distinctcount(Table[Name]), filter(Table, isblank(Table[email])))
with email =
calculate(distinctcount(Table[Name]), filter(Table, not(isblank(Table[email]))))
Hi, thanks for your reply.
Given that the 'email' field doesn't have blank value, I used the measure below.
Email Registration = calculate(distinctcount('Zendesk Customer History'[Email]),
filter('Zendesk Customer History',
CONTAINSSTRING('Zendesk Customer History'[Email],"@")))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |