Forum Discussion
Helper IIDAX measure help
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
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],"@")))
2 Replies
- amitchandak
Super User
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]))))
RenataOGardnerHi, 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],"@")))
