Remove duplicates from a SUMX function using columns from multiple tables in DAX

Hi msciarrino ,

Please try to create measure with below dax formula:

Measure =
VAR cur_id =
    SELECTEDVALUE ( Table1[ID Numbers] )
VAR _a =
    CALCULATE (
        MAX ( Table1[Quantity] ),
        FILTER ( ALL ( Table1 ), [ID Numbers] = cur_id )
    )
VAR _b =
    CALCULATE (
        MAX ( 'Table 2'[Price] ),
        FILTER ( ALL ( 'Table 2' ), [ID Numbers] = cur_id )
    )
VAR _r1 = _a * _b
VAR tmp =
    SUMMARIZE (
        ALL ( Table1 ),
        Table1[ID Numbers],
        "QTY", MAX ( Table1[Quantity] )
    )
VAR _c =
    CALCULATE ( MAX ( Table1[Quantity] ), FILTER ( tmp, [ID Numbers] = cur_id ) )
RETURN
    _r1

Measure 2 = SUMX(VALUES(Table1[ID Numbers]),[Measure])

Add a table visual with fields and measure:

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.