Count quantity of repeating ID

[azaterol]

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

[azaterol]

Thank ya all!  @amitchandak  @Arul 

[amitchandak]

@azaterol , Please follow @Arul Suggestions. But I think you need SUM, In place of count.

[Arul · Accepted solution]

@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