I have a dataset with session IDs and pages... I want to know how many distinct session IDs include a specific page ('ABC'). The trick is one session ID could have multiple rows with page ABC...
Session ID -- Page
123 -- ABC
123 -- ABC
123 -- DEF
456 -- DEF
456 -- ABC
789 -- GHI
Hypothetically, how do I create a beastmode to count distinct session IDs with ABC as 2?