Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
RenataOGardner
Helper II
Helper II

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.

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.

 

 

RenataOGardner_0-1621346733385.png

 

RenataOGardner_1-1621346853286.png

 

This is what I have on the table.

 

RenataOGardner_2-1621347221611.png

 

Many thanks,

Renata

 

 

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
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]))))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.