Number of items per order

[livios]

Hi,

I have 1 table with orders from users and I have 6 different products/productids:

id

userid

productid

I would like to know how many users ordered 1 product, 2 products etc.

NrOfProducts	NrOfUsers
1	50
2	69

How can I do this?

[amitchandak · Accepted solution]

@livios , You have use dynamic segmentation

First create  1 measure
NrOfProducts = Count(Table[productid])

then create a new Table
bucket = Generateseries(1,100,1)

Use a  new Measure with bucket value in visual
Countx(filter(Values(Table[user]), [NrOfProducts] = max(bucket[Value])), [User])

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k