Top N rows and SUm

[krishnakumar_Ra]

Team - I have table of 100 rows as below

Need a Measure to add top 3 rows.. only on population (total = 6)

I googled but could not find any 

Country	Population
aa	2
bb	3
cc	1
dd	10

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below.

The top 3 sum is depending on the index of the country.

Population measure: = 
SUM( Data[Population] )

WINDOW function (DAX) - DAX | Microsoft Learn

expected result measure: =
CALCULATE (
    [Population measure:],
    KEEPFILTERS (
        WINDOW (
            1,
            ABS,
            3,
            ABS,
            ALL ( Data[Country Index], Data[Country] ),
            ORDERBY ( Data[Country Index], ASC )
        )
    )
)