Frequent Flyers

Hi James314 ,

Please try like:

MEASURE = 
COUNTROWS (
    FILTER (
        SUMMARIZE (
            'Table',
            'Table'[Location],
            'Table'[User ID],
            "@count", COUNT ( 'Table'[User ID] )
        ),
        [@count] > 5
    )
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group