Forum Discussion
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".
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]))))
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
2 Replies
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
Great - worked perfectly. Thanks for your help!
