I have two tables, CSMs and Issues. The CSMs table has one column, CSM and it's text column which is a list of about 20 names.
The Issues table has a text column called CSM that contains the same names as the CSMs table, but sometimes there are multiple names in that column separated by commas.
I want to add a slicer to a page with its Field being 'CSMs'[CSM] but when a name is selected in the slicer, the Issues table is filtered not just by rows with that exact match in the CSM column but any row where the selected name exists in the CSM column.
I can't see that you can apply the in operator to a relationship between two tables, and if I split the 'Issues'[CSM] into rows on the comma it'll stuff up all my measures.
How can I solve this, I'm happy using Power Query or DAX.