Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

largets 4 with multiple same values

Hi All! I am currently trying to do a sum of the four largets points in a column. My problem is, that I have multiple rows with the same amount of values, and i do only want to sum the top four ro...
Need Help
MahyarTF's avatar
MahyarTF
Memorable Member
3 years ago

Hi,

Please use below measure for distinct top N rows sum :

SumTopN =
CALCULATE( sumx(TOPN(4, VALUES(Sheet119[Number]), Sheet119[Number],DESC), Sheet119[Number]))

 

Appritiate your Kudos and please mark it as a solution if it helps you .