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

     

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