SUMX, and filter where 2 different columns containstring

[hpayne93]

Hi,

I need to calculate the total number of website log ins by adding the number of 'GA4 Sessions'[data.event_count] where the [pagetitle] contains "login" OR the [event_name] contains "login".

Can you tell me where I'm going wrong? 

Thanks!

Logins = SUMX(

    FILTER(

        'GA4 Sessions',

        CONTAINSSTRING('GA4 Sessions'[data.event_name], "login") || CONTAINSSTRING('GA4 Sessions'[data.pagetitle], "login",

'GA4 Sessions'[data.event_count]))))

[v-shex-msft · Accepted solution]

HI @hpayne93,

It seems like you missed the right brackets of the second CONTAINSSTRING function, you can try to use following measure formula if helps:

Logins =
SUMX (
    FILTER (
        'GA4 Sessions',
        CONTAINSSTRING ( 'GA4 Sessions'[data.event_name], "login" )
            || CONTAINSSTRING ( 'GA4 Sessions'[data.pagetitle], "login" )
    ),
    'GA4 Sessions'[data.event_count]
)

In addition, if you are check different fields with the same conditions at the same time, you can try or concatenate them and search the concatenate strings:

Logins =
SUMX (
    FILTER (
        'GA4 Sessions',
        SEARCH ( "login", [data.event_name] & "," & [data.paetitle], 1 ) > 0
    ),
    'GA4 Sessions'[data.event_count]
)

Regards,

Xiaoxin Sheng

[hpayne93]

Great - worked perfectly. Thanks for your help!