Sum of column without duplicate

[Piinherio]

Hello,

I want to sum the project Item Qty but for both projects but without duplicate, example sum of project items for same item nr. Is 845 + 200 = 1045

while in project C it should calculate 1089

Thanks in advance. 

[Arul · Accepted solution]

@Piinherio ,

try this measure,

Distinct sum = 
VAR _distinctValues = VALUES('Table'[Price Item Quantity])
VAR _result = SUMX(_distinctValues,[Price Item Quantity])
RETURN _result

Thanks,

Arul