Sum by distinct ID from duplicated rows

[Anonymous]

I have a non aggregated table that is transactional based on event that has duplicated ID's and Amounts similar to column a/b and I would like to have a measure to apply in my visualizations that shows the uniqe amount by order ID and then I can roll up to Vendor.   How would I write a formula to do this on the report side?  One of my attempts is:  

vsum = CALCULATE(sum('TABLE_1'[Amount]), ALLSELECTED(MAX('TABLE_1'[OrderID])))

Order ID	Vendor	Amount	ID	Vendor	Amount
417306	A	67.80	417306	A	67.80
417306	A	67.80	503477	B	269.85
417306	A	67.80	525849	C	204.53
417306	A	67.80
417306	A	67.80
417306	A	67.80
417306	A	67.80
417306	A	67.80
503477	B	269.85
503477	B	269.85
503477	B	269.85
503477	B	269.85
525849	C	204.53
525849	C	204.53
525849	C	204.53
525849	C	204.53
525849	C	204.53
525849	C	204.53
525849	C	204.53
525849	C	204.53
525849	C	204.53
525849	C	204.53
525849	C	204.53
525849	C	204.53

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

Give this a try, you will just have to change the name of your table in the measure.

Measure = 
VAR XTable = SUMMARIZE(Table1,Table1[Vendor],Table1[Order ID])
RETURN
SUMX(XTable,MAX(Table1[Amount]))

[Anonymous]

Thank you @jdbuchanan71  for the quick reply, this gave me exactly what I was looking for.