DAX measure help

[RenataOGardner]

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

[amitchandak]

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

[RenataOGardner · Accepted 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],"@")))