Forum Discussion

hpayne93's avatar
hpayne93
Frequent Visitor
3 years ago
Solved

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.    News...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • vk_pbi's avatar
    vk_pbi
    3 years ago

    Try this

    CALCULATE(
SUM('Mailchimp Campaign'[Send]), 
FILTER(
	'Mailchimp Campaign',
	CONTAINSSTRING('Mailchimp Campaign'[Name],"newsletter")
),
USERELATIONSHIP('Mailchimp Campaign'[Sent On],'Date'[Date]))
hpayne93's avatar
hpayne93
Frequent Visitor
3 years ago

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's avatar
vk_pbi
Resolver II
3 years ago

Try this

CALCULATE(
SUM('Mailchimp Campaign'[Send]), 
FILTER(
	'Mailchimp Campaign',
	CONTAINSSTRING('Mailchimp Campaign'[Name],"newsletter")
),
USERELATIONSHIP('Mailchimp Campaign'[Sent On],'Date'[Date]))
  • hpayne93's avatar
    hpayne93
    Frequent Visitor
    3 years ago

    It worked! Thanks very much