Forum Discussion
hpayne93
3 years agoFrequent Visitor
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". ...
- Anonymous3 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
Anonymous
3 years agoNot applicable
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
- hpayne933 years agoFrequent Visitor
Great - worked perfectly. Thanks for your help!