Filter data based on a comma separated list using CALCULATE and PATHCONTAINS, even with external models!
Another interesting question I got this week kind of extends on the previous blog posts where I used disconnected slicers to filter data but this time instead of having the data already in the model the request was to allow to write a filter based on a comma separated list. So off we go again into the DAX rabbit hole 
I decided I wanted to extend the previous example with this question. I created a new matrix visual and added the measure that shows the sales based on the data from the slicer selected (as discussed in the previous blog post). Next I added a measure that contains the list they want to filter. So now in this case I want to see sales for Colors Red, Green, Gold as entered in the comma separated list: