How to create dax to find max salary in same column

[sivarajan21]

Hi,

I have these below two sample datasets:

PFA sample file in below link:

To find max salary.pbix

Worker table:

worker_id	first_name	last_name	salary	joining_date	department
1	Monika	Arora	100000	20/02/2014 00:00	HR
2	Niharika	Verma	80000	11/06/2014 00:00	Admin
3	Vishal	Singhal	300000	20/02/2014 00:00	HR
4	Amitah	Singh	500000	20/02/2014 00:00	Admin
5	Vivek	Bhati	500000	11/06/2014 00:00	Admin
6	Vipul	Diwan	200000	11/06/2014 00:00	Account
7	Satish	Kumar	75000	20/01/2014 00:00	Account
8	Geetika	Chauhan	90000	11/04/2014 00:00	Admin
9	Agepi	Argon	90000	10/04/2015 00:00	Admin
10	Moe	Acharya	65000	11/04/2015 00:00	HR
11	Nayah	Laghari	75000	20/03/2014 00:00	Account
12	Jai	Patel	85000	21/03/2014 00:00	HR

title table:

worker_ref_id	worker_title	affected_from
1	Manager	20/02/2016 00:00
2	Executive	11/06/2016 00:00
8	Executive	11/06/2016 00:00
5	Manager	11/06/2016 00:00
4	Asst. Manager	11/06/2016 00:00
7	Executive	11/06/2016 00:00
6	Lead	11/06/2016 00:00
3	Lead	11/06/2016 00:00

We need to find the job titles of the highest-paid employees using dax.

Your output should include the highest-paid title or multiple titles with the same salary.

The expected output would be:

worker_title	salary
Asst. Manager	500000
Manager	500000

Could you please help me in creating a dax?

Thanks in advance

@Ahmedx @lbendlin @Greg_Deckler @amitchandak @Ashish_Mathur 

[Greg_Deckler · Accepted solution]

@sivarajan21 Maybe something like the attached PBIX. You can use either an explicit or implicit MAX coupled with a Top N filter.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.  Mine is a measure based solution without using the Top n filter from the Filter pane.

Hope this helps.

[sivarajan21]

Hi Ash,

Thanks for your solution😊

[Ashish_Mathur]

You are welcome.

[Greg_Deckler · Accepted solution]

@sivarajan21 Maybe something like the attached PBIX. You can use either an explicit or implicit MAX coupled with a Top N filter.

[sivarajan21]

Hi @Greg_Deckler ,

Apologise for delay in response!

Thats an amazing solution and you made it look so easy😊

This is what I was looking exactly and I have noted this TOPN function for future reference.

I will accept this as solution and close this query.

Thanks a lot to you and beautiful community.