4th highest revenue generating product

[MSMKM]

Hi Team,

Need to find out the 4th highest revenue generating product

here the data

orderno, productName, revenue
1,a,100
2,b,200
3,c,300
4,d,50
5,e,800

[tamerj1 · Accepted solution]

Hi @MSMKM 
Please try

4th Highest Product =
MAXX (
    TOPN (
        1,
        TOPN (
            4,
            VALUES ( 'Table'[productName] ),
            CALCULATE ( SUM ( 'Table'[revenue] ) ), DESC
        ),
        CALCULATE ( SUM ( 'Table'[revenue] ) ), ASC
    ),
    'Table'[productName]
)