If your data size is relatively small you could try adding a custom column with the code:
List.Count(Text.PositionOf([Test], "ticket", Occurrence.All))