Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

SUM based on distinct values from another column

Hello 🙂 I have a table in the following format: Product_ID Weight Classification 1 50 A 1 50 B 2 10 A 2 10 C 2 10 C 3 20 B As you can see, t...

3 years ago

Anonymous,

Try this measure:

Sum Product Weight = 
SUMX (
    SUMMARIZE ( Table1, Table1[Product_ID], Table1[Weight] ),
    Table1[Weight]
)

Super User

3 years ago

Anonymous,

Try this measure:

Sum Product Weight = 
SUMX (
    SUMMARIZE ( Table1, Table1[Product_ID], Table1[Weight] ),
    Table1[Weight]
)