Sum values in column on Unique value

[Anonymous]

OrderID	OrderTotal	Item
000123	100	0078
000123	100	0081
000123	100	0096
000789	59	0078

The Total returned for order 000123 was 300 when it really should be 100. So the totals for all orders returned as 359 when really it was 159.

I tried the following DAX code but it returned all 0's.  I want to be abel to return the sum of OrderTotals for only unique OrderID's. 

Total = SUMX(DISTINCT(Data[OrderID]), FIRSTNONBLANK(Data[OrderTotal], 0))

[v-yetao1-msft · Accepted solution]

Hi @Anonymous 

I restore your data and create a sample , the sum of [OrderID] is 159 . I have attached my pbix file , you can refer to it and check the original data in your sample .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[freginier]

what's the excepted result ?