Forum Discussion

hpayne93's avatar
hpayne93
Frequent Visitor
3 years ago
Solved

SUMX, and filter where 2 different columns containstring

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". ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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