largets 4 with multiple same values

[Anonymous]

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 rows, not the top four values. In the below I would like to get a sum of 125 and not 173.

I have also assed, that I cannot create a new table with distinct, as the first four rows in principle could be the same number. 

Can you help with this problem?

[Anonymous]

Hi, Mahyartf
The measure does not quit work, as in the below scenario it return 119 insted of 120 which is the correct number: 

[MahyarTF]

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 .