How Can a Segment Show More Users Than the Total?

[TomaszLooker]

I’m analyzing GA4 data in Looker and ran into something strange.

I grouped users by page paths using this logic:

CASE
  WHEN CONTAINS_TEXT(Page path and screen class, '/usa/') THEN 'usa'
  WHEN CONTAINS_TEXT(Page path and screen class, '/pri/') THEN 'pri'
  WHEN CONTAINS_TEXT(Page path and screen class, '/dom/') THEN 'dom'
  ELSE 'other'
END

Here’s the screenshot for context:

In the results:
• Total Users = 12,503 (imported directly from GA4).
• The “USA” segment alone shows 27,724 users, which is more than the total!

Has anyone seen this before? How can a segment have more users than the total?

[ArkadyZagdan]

@TomaszLooker 
Try troubleshootinng at row level with a  table. you never knnow what you can find 😉

[TomaszLooker]

@ArkadyZagdan 

I have created an additional table. I filtered page path and screen class by text "/usa/".
: 
The sum of all 857 rows from this table is 27724 (number from the table in the post).

[ArkadyZagdan]

@TomaszLooker 
Sorry, cannot reproduce at my end. Works just correct. Maybe a bug.