Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
azaterol
Helper V
Helper V

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. 

owww.PNG

Like the picture below, the result should be:

OrderID   countQuantity

10327       65

10328       59

10329       50

10330       75

 

Thank you all

1 ACCEPTED SOLUTION
Arul
Super User
Super User

@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,

Arul_0-1652861961628.png

Thanks,

Arul

 

Thanks,

Arul

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


View solution in original post

3 REPLIES 3
azaterol
Helper V
Helper V

Thank ya all!  @amitchandak  @Arul 

amitchandak
Super User
Super User

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

 

Arul
Super User
Super User

@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,

Arul_0-1652861961628.png

Thanks,

Arul

 

Thanks,

Arul

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.