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 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?

 

 

Need Help

2 Replies

  • 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 .

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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