Forum Discussion
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 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.
= SUMX( VALUES( Table1[Name] ) , CALCULATE( MAX( Table1[Value] ) ) )
