Complex: Filtering data by name

MurugeshC ,

I went ahead and did this using power query, so I attached the pbix file below. But I went off using this example:

After loading that table into PowerQuery:

• Split the "Fruits" column by delimiter and to new rows, not columns. giving this table
• 
• Group this new table by project and aggregate all data
• Add a new column wiht this code

List.Accumulate( [All Data][Fruits],"", (state,current) => state &","
& current )

which produces this column:

Expand that table out

Do some misc clean up and you get this final table

Then just to make the data model complete, created a dimFruits and DimList table which would be used to filter the above table

Final output

File:

https://1drv.ms/u/s!Amqd8ArUSwDS1TYkrRtY1efnZd8m