Select a value of text column having maximum salary

[Anonymous]

Hello team

I want to add a dynamic measure in which I want to show the value having maximum salary.
Table 
---------------------------------------
Name                             Salary

Aidan                             25000

Sukhman                       90000

Pranav                           15000

So my measure should return only single value which is Pranav here.

Please help me to write this dax measure.

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

Try it

Measure = 
var _max=CALCULATE(MAX('Table2'[Salary]),ALL(Table2))
return CALCULATE(MAX('Table1'[Name]),FILTER('Table2',[Salary]=_max))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

Try this measure.

Measure = 
var _max=CALCULATE(MAX('Table'[Salary]),ALL('Table'))
return CALCULATE(MAX('Table'[Name ]),FILTER(ALL('Table'),[Salary]=_max))

Since 90,000 > 25,000 > 15,000, shouldn't the biggest be Sukhman? so the final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @v-yalanwu-msft 
It works fine with one table.
Lets say we have table table1 having Name table1[Name] and second one table2[Salary]. 
Table1:

Name	ID
Pranav	1
Sukhman	2
Aidan	3

Table2:

ID	Salary
1	15000
2	25000
3	90000

[amitchandak]

@Anonymous , Use TOPN

TOP1 Name= CALCULATE([Net], TOPN(2,ALLSELECTED('Item'[Name]), calculate(Sum(Table[Salary])) ,DESC), values('Item'[Name]))