topic Re: 4th highest revenue generating product in DAX Commands and Tips

4th highest revenue generating product

MSMKM — Wed, 29 Mar 2023 11:09:27 GMT

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

Re: 4th highest revenue generating product

tamerj1 — Wed, 29 Mar 2023 11:27:47 GMT

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] )