So I am having an issue creating a new measure which will count the number of items selected in a multiselect field.
This image show currently [Measures].[Creative - Brand Selection(s)]. This is a multiselect field with a number of options. For some other measures we would like to make we need to know how many options were selected. I have tried using Count, but as it is just a string being returned the count is 1. Any help on this would be appreciated