Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have these below two sample datasets:
PFA sample file in below link:
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 |
Solved! Go to Solution.
@sivarajan21 Maybe something like the attached PBIX. You can use either an explicit or implicit MAX coupled with a Top N filter.
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.
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.
Hi Ash,
Thanks for your solution😊
You are welcome.
@sivarajan21 Maybe something like the attached PBIX. You can use either an explicit or implicit MAX coupled with a Top N filter.
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.
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |