topic Re: Sum based on ranking in DAX Commands and Tips

Sum based on ranking

JakeandSnake — Thu, 20 May 2021 15:01:22 GMT

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 names with the highest score. (in the red circle).

Anyone has a way to solve this by using DAX? No additional table can be created.

Thanks.

CNENFRNL — Thu, 20 May 2021 15:23:15 GMT

= SUMX( VALUES( Table1[Name] ) , CALCULATE( MAX( Table1[Value] ) ) )

JakeandSnake — Thu, 20 May 2021 15:47:42 GMT

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

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