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 nu...
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

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

 

 

Rfranca's avatar
Rfranca
Resolver IV
7 years ago

 
did not work!
  • 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

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

      Hi Rfranca,

       

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

       

      Regards,
      Frank