Items per orders

[Rfranca]

I have a table with order items. I need to calculate the order quantity with 1, 2, 3 ... items per order.

ex.
With 1 item = 20 orders
With 2 items = 15 orders

I have a column with the order number and another column with the item number in the order.

i tried this but it didnt work

[AlB]

Hi @Rfranca

Try this:

1. Place a matrix visual in your report

2. Place the 'item numbers' column in the rows of the matrix

3. Place this measure in the values of the matrix: 

NumberOfOrders = DISTINCTCOUNT(Table1[OrderNumberColumn])

[Rfranca]

did not work!

[v-frfei-msft · Accepted solution]

Hi @Rfranca,

Please change your formula as below.

Numberoforders = Distinctcount(venda_item_geral[id_Vendeachane])

If that doesn't meet your requirement, kindly share your pbix to me.

Regards,

Frank

[v-frfei-msft]

Hi @Rfranca,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank