Hi Chenyi- Julianne from Mixpanel Support here!
Diving right in, in my test project I'm still able to filter using 'contains' with the 'Distinct ID' (example in screenshot below). Is there a specific place in the product where you aren't seeing that option?
Inline Attachment: image.png