Is this field a string? Do you have access to create a custom field in the Quicksight dataset?
If so you may be able to use the split function to create a separate field for each item in the {Source} field and the do a count on each newly created fields and sum those values.