Forum Discussion

RenataOGardner's avatar
RenataOGardner
Icon for Helper II rankHelper II
5 years ago
Solved

DAX 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. ...
Need Help DAX
  • RenataOGardner's avatar
    RenataOGardner
    5 years ago

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
RenataOGardner
Icon for Helper II rankHelper II
5 years ago

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