Forum Discussion

azaterol's avatar
azaterol
Icon for Helper V rankHelper V
4 years ago
Solved

Count quantity of repeating ID

Hey all,

how do I can make a measure, to count the quantity together, if the OrderID is the same. 

Like the picture below, the result should be:

OrderID   countQuantity

10327       65

10328       59

10329       50

10330       75

 

Thank you all

Need Help
  • Arul's avatar
    Arul
    4 years ago

    azaterol ,

    If you want to make a measure then just create the below measure and drag orderID and measure together to  into the visual.

    Countof QTY = COUNT(Table[Quantity])

    If you don't want to write the measure then use the below method just right click on the field then choose the aggregation method,

    Thanks,

    Arul

     

    Thanks,

    Arul

     

3 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    4 years ago

    azaterol ,

    If you want to make a measure then just create the below measure and drag orderID and measure together to  into the visual.

    Countof QTY = COUNT(Table[Quantity])

    If you don't want to write the measure then use the below method just right click on the field then choose the aggregation method,

    Thanks,

    Arul

     

    Thanks,

    Arul