Forum Discussion
Filter and List columns
In my table I have a column titled name, which lists pizzas by name. I have another column that lists each ingredient in that pizza on seperate rows. I want to see if there is a way for me to show how many pizzas use a specific ingredient. Here is a snip of part of my data set. I am basically trying to figure out what are the top ingredients used and the least used. For product maximization.
2 Replies
- Pragati11Super User
HI mweber87 ,
Can you please share this sample data in a file format?
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- jgordon11Resolver II
tbl = Table.FromColumns({List.Distinct(Source[ingredients])},{"ingredients"}),
tbl1 = Table.AddColumn(tbl, "Count of Pizzas", each List.Count(List.Select(Source[ingredients], (x)=> x = [ingredients])))