how to make

[Anonymous]

Hi, all

I don't know if I explain what I want to do well.

Anyway, what I want to do is count how many items the customer has for each combination like Ex1).
And also like Ex2), I want to count how many apples(or banana...) there are among the combinations,

so I hope the results come out as follows EX2) when I apply a filter.
Let me know if this is possible.

Thanks

[VijayP]

@Anonymous 

If you find this as solution please mark this as accepted solution ! Thanks

[VijayP · Accepted solution]

@Anonymous 

Bit powerquery ETL REquired . Filte attached for your understanding Share your Kudos

[Anonymous]

I solved it.

Thank you