QuickSight - Can I use countif + contains?

Hi, I'd like to count if a field (string) has a certain text included.

Already tried:

• countIf({ID}, {Ticket type} contains 'Wochenend')
• distinct_countIf({ID}, {Ticket type} like '%Wochenend%')
• distinct_countif({ID}, locate(toLower({Ticket type}), 'Wochenend') <> 0) ...but nothing worked.

Would appreciate help from the community!

Many thanks, Axel