Forum Discussion

Rfranca's avatar
Rfranca
Resolver IV
7 years ago
Solved

Items per orders

 

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

 

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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

4 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    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])

     

     

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        7 years ago

        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