How to count customers who have purchased different counts of products in each purchase?

[Velocity]

Hi,

I am trying to find out how many items are purchased in each purchase.

Given below is sample data and desired output in cells E4 to J5. There are 29 products purchased. There are 4 customers who purchased single item, 6 customers purchased 2 items and one customer each purchased  3, 4 and 6 products.

I would like to know how to handle it in DAX.

Thanks,

[amitchandak]

@Velocity , refer if this can help you

https://www.daxpatterns.com/dynamic-segmentation/

https://www.daxpatterns.com/static-segmentation/

[Velocity · Accepted solution]

Hi @amitchandak,

I used a different approach (using summary tables) to get the desired result. Issue is resolved now. 

Thanks,

[Ani26]

Hi @Velocity 

Can you please help us with the solution as well?

Thanks,

Ani