Summarize Work Orders to show one total for one work order

[dferry]

I have a table with numerous work orders.  I want to create a measure using DAX to sum each work order so the results just show one work order  with a total.  The columns are Work Order, Date, quantity used and sell.  If a work order is listed more than once it is because it lists a line for each line  item.  So if there were five different parts it would have five lines listed for each part with the quantity used and the sell of each.  Some work orders will only have one line if only one part was used.  If i was doing in a pivot table it summarizes each individual work order with a total.  The screen shot only shows a few of the columns.

Thanks,

Doug

[technolog]

Can you please tell me if the problem is still relevant? If you managed to solve it in some way, please write here how you solved this problem. Then it will be possible to mark this problem as solved.

If not, it may make sense to ask the question again, thus confirming the relevance of this problem.