How to show different variations of values within the same column?

[Anonymous]

Hi and appreciate any ideas on a DAX measure to solve this one. I'd like a measure that allows me to show the count of different variations on the Checklist column. For example, how many Apples were Squeezed, or how many Apples, Oranges were Squeezed, or how many Oranges and Bananas were Mixed, etc, etc.

It's based on a work database i use that has a similar checklist column (just not fruit). That is, it has a range of different values in the same column that can probably be grouped into different columns of their own. But the only way they are grouped differently is via the Category column.

Thanks in advance (fruit basket to whoever gets it!)

[amitchandak]

@Anonymous , I do see ant relation between Fruit and style. So I doubt that. If there is, please share sample data and sample output in table format.

[Anonymous]

Hi and thanks a lot for responding. I think you're right in that there is no independent relationship between Fruit and Style. Both the Category and Checklist are contained in their own query (a dimension table). The Event Code is from a fact table across the data set. The relationship between the dimension and fact table is via the Event Code. Appreciate you taking a look, thanks again!

Event Code	Category	Checklist	Count
10	Fruit	Apples	1
10	Style	Squeezed	1
15	Fruit	Apples	1
15	Style	Mixed	1
20	Style	Mixed	1
20	Fruit	Apples, Oranges	1
25	Fruit	Bananas	1
25	Style	Mashed	1
30	Fruit	Bananas and Apples, Oranges	1
30	Style	Mixed	1
35	Style	Mixed	1
35	Fruit	Apples, Oranges	1
40	Style	Mixed	1
40	Fruit	Apples, Oranges	1
45	Style	Mixed	1
45	Fruit	Apples, Oranges	1
50	Fruit	Apples	1
50	Style	Squeezed	1
55	Fruit	Apples	1
55	Style	Mixed	1
60	Style	Mixed	1
60	Fruit	Apples, Oranges	1
70	Fruit	Apples, Oranges	1
70	Style	Squeezed	1
80	Fruit	Apples	1
80	Style	Squeezed	1

[v-easonf-msft]

Hi, @Anonymous 

I'm a little confused by your description. 

Can you post your expected output?

Best Regards,
Community Support Team _ Eason

[Anonymous · Accepted solution]

Hey and thanks for replying. Not to worry, it's not something that can be done as no relationship exists between the values within the checklist column. They need to separated out into another column for it to work. All the best.