Largest amount by person

[Ethanhunt123]

I have a table that has many columns. (date, User, Amount etc). I need to find the user that has the largest amount regardless of any other column(date, etc).

The output will be GHI and 1000

Name	Amount
ABC	100
DEF	200
GHI	1000
JKL	350

[amitchandak · Accepted solution]

@Ethanhunt123 ,

lastnonblankvalue(Table[Amount], max(Table[Name]))

select with un summarized Amount. Else create a Rank and filter on 1 or use top 1

sales =sum(Table[Amount])

Rank = RANKX(all(Table[Name]),[Sales])


Rank Top 1= CALCULATE(if([Rank]=,[Sales],BLANK()) ,VALUES(Table[Name]))
Rank Top  1 = sumx(VALUES(Table[Name]),if([Rank]=1,[Sales],BLANK()) )
Top 1 Rank = CALCULATE([Sales],TOPN(1,all(Table[Name]),[Sales],DESC),VALUES(Table[Table]))

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
Rank 2nd top = sumx(filter(VALUES(Geography[City]),[City Rank]=2),[Sales] )

[Ethanhunt123]

How it will handle the situation when 2 rows have same amount