Forum Discussion

JakeandSnake's avatar
JakeandSnake
Frequent Visitor
5 years ago
Solved

Sum based on ranking

Hi,    I'm trying to work out a DAX to solve the below problems, but cannot figure it out myself.    The above table has three columns, and my objective is to sum up the value for all the n...
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago
    = SUMX( VALUES( Table1[Name] ) , CALCULATE( MAX( Table1[Value] ) ) )
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago
= SUMX( VALUES( Table1[Name] ) , CALCULATE( MAX( Table1[Value] ) ) )
JakeandSnake's avatar
JakeandSnake
Frequent Visitor
5 years ago

**bleep**! It works! CNENFRNL Thank you!

Could you help to elaborate a bit on the logic of this DAX? Want to learn. 🙂