Multi Select Filter off comma separated values

Multi Select Filter off comma separated values

Hey friends!

I have a query table for a couple of dashboards/ charts. In one of the dashboards, I'm trying to create a multi select filter for the service that is being sold. The way we look at services is by a CRM field titled, "Mail Lead Entities," "eBill Lead entities," etc. 

In my Query Table, I have the following case:

Case
When L."Mail Lead Entities"  > 0 then 'Mail'
When L."eBill Lead Entities"  > 0 then 'eBill'
When L."Pay Lead Entities"  > 0 then 'Pay'
When L."FlexPay Lead Entities"  > 0 then 'FlexPay'
When L."Collections Lead Entities"  > 0 then 'Collections'
End as 'Service',

Obviously adding a multiselect filter for Service won't work properly as this new Service column will only ever have one of the services listed, when it is indeed possible (if not likely) to have multiple services in a single lead. Is there any way to accomplish what I'm trying to do?

Let me know if question is not clear.

Thanks!