how to get the count of data

[Anonymous]

Hi all,

I want to count the count of the menu for each mixed menu like below.
I only have the left data.
So I think I should make a new table with mixed menus like right table.
But I don't know what to do next and how to make Dax fun.

Thanks for advance.

[amitchandak · Accepted solution]

@Anonymous , Create a new column and use that in visual

combination =

concatenateX(summarize(filter(Table, [consumer] =earlier([consumer])),[item]), [item] , "+",[item],1)

[Anonymous]

Thank you SO much.

If I want to drop the orange.

how to make combination_new?

I tried to use IF function, but fail...