topic NOT(CONTAINSSTRING) - multiple values in DAX Commands and Tips

NOT(CONTAINSSTRING) - multiple values

cn4422 — Fri, 15 Nov 2024 12:16:44 GMT

Hi,

I'm trying to implement a measure with NOT(CONSTAINSSTRING) with 2 values, as in the following example:

Test =

CALCULATE(

SUM('GA, FB, Spend'[spend]),

'GA, FB, Spend'[account_name] = "DE",

CONTAINSSTRING('GA, FB, Spend'[campaign], "Gemischt*"),

NOT(CONTAINSSTRING('GA, FB, Spend'[ad_group_name], "PR01*") && NOT(CONTAINSSTRING('GA, FB, Spend'[ad_group_name], "PR02*")

)))

The first NOT(CONTAINS) filter is working but the second one is being ignored.

Any idea what's wrong with this measure?

Thx in advance! 🙂

Re: NOT(CONTAINSSTRING) - multiple values

johnt75 — Fri, 15 Nov 2024 13:28:14 GMT

I think you might have the nesting wrong. What you currently have is

Test = CALCULATE ( SUM ( 'GA, FB, Spend'[spend] ), 'GA, FB, Spend'[account_name] = "DE", CONTAINSSTRING ( 'GA, FB, Spend'[campaign], "Gemischt*" ), NOT ( CONTAINSSTRING ( 'GA, FB, Spend'[ad_group_name], "PR01*" ) && NOT ( CONTAINSSTRING ( 'GA, FB, Spend'[ad_group_name], "PR02*" ) ) ) )

If you're trying to exclude both PR01 and PR02 try

Test = CALCULATE ( SUM ( 'GA, FB, Spend'[spend] ), 'GA, FB, Spend'[account_name] = "DE", CONTAINSSTRING ( 'GA, FB, Spend'[campaign], "Gemischt*" ), NOT CONTAINSSTRING ( 'GA, FB, Spend'[ad_group_name], "PR01*" ) && NOT CONTAINSSTRING ( 'GA, FB, Spend'[ad_group_name], "PR02*" ) )

Re: NOT(CONTAINSSTRING) - multiple values

cn4422 — Fri, 15 Nov 2024 13:39:48 GMT

johnt75 Ah, thank you very much, that did the trick! 👌