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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hpayne93
Frequent Visitor

DAX with text filter

Hi,

 

I need to add a new measure to sum the total of newsletter sends. Currently my measure shows the total of ALL email campaign sends - this includes newsletters, webinar invites etc. 

 

Newsletter sends = CALCULATE(SUM('Mailchimp Campaign'[Send]), USERELATIONSHIP('Mailchimp Campaign'[Sent On],'Date'[Date]))
 
What do I need to add to my measure so I am only calculating sends where the 'name'(mailchimp campaign) column contains 'newsletter'?
 
Thanks!
1 ACCEPTED SOLUTION

Try this

CALCULATE(
SUM('Mailchimp Campaign'[Send]), 
FILTER(
	'Mailchimp Campaign',
	CONTAINSSTRING('Mailchimp Campaign'[Name],"newsletter")
),
USERELATIONSHIP('Mailchimp Campaign'[Sent On],'Date'[Date]))

View solution in original post

5 REPLIES 5
grazitti_sapna
Resolver I
Resolver I

To calculate the total number of newsletter sends, you can modify your measure by adding a filter condition using the CONTAINS function. Here's an example of how you can modify your measure to only calculate sends where the 'name' column contains 'newsletter':

Newsletter sends =

CALCULATE(

SUM('Mailchimp Campaign'[Send]),

USERELATIONSHIP('Mailchimp Campaign'[Sent On], 'Date'[Date]),

CONTAINS('Mailchimp Campaign', 'Mailchimp Campaign'[name], "newsletter")

)

Thank you 

vk_pbi
Resolver II
Resolver II

Hi @hpayne93 

I havent' tested the below code, it should work

CALCULATE(
SUM('Mailchimp Campaign'[Send]), 
FILTER(
	'Mailchimp Campaign',
	'Mailchimp Campaign'[Name] = 'newsletter'
),
USERELATIONSHIP('Mailchimp Campaign'[Sent On],'Date'[Date]))

 

Hey, thanks for the reply!

 

That doesn't quite work. I want to see the total where 'mailchimp campaign' [name] contains 'newsletter' -- do i need to use CONTAINSSTRING?

Try this

CALCULATE(
SUM('Mailchimp Campaign'[Send]), 
FILTER(
	'Mailchimp Campaign',
	CONTAINSSTRING('Mailchimp Campaign'[Name],"newsletter")
),
USERELATIONSHIP('Mailchimp Campaign'[Sent On],'Date'[Date]))

It worked! Thanks very much 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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