DAX with text filter

[hpayne93]

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!

[grazitti_sapna]

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]

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

[hpayne93]

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?

[vk_pbi · Accepted solution]

Try this

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

[hpayne93]

It worked! Thanks very much