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

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