Forum Discussion

Ericwhv's avatar
Ericwhv
Helper II
5 years ago
Solved

Sumx with Distinct Value

Hi Everyone 🙂 not sure if anyone could help me currently, i am working on the total weight of below table but you can see some of the File Ref is duplicate, i just need the weight of Distinct Fi...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, Ericwhv , you might want to try this measure

    SUMX( DISTINCT( Table1[File Ref] ), CALCULATE( MAX( Table1[Weight] ) ) )

     

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, Ericwhv , you might want to try this measure

SUMX( DISTINCT( Table1[File Ref] ), CALCULATE( MAX( Table1[Weight] ) ) )

 

ed185's avatar
ed185
Regular Visitor
4 years ago

Hi,

Does anyone know what is the difference between :

SUMX( DISTINCT( Table1[File Ref] ), CALCULATE( MAX( Table1[Weight] ) ) )

and

SUMX( DISTINCT( Table1[File Ref] ), MAX( Table1[Weight] ) )

 

Both don't lead to the same results in my example.

Thanks.