Forum Discussion
Top 3 values in a row in Table
Thanks for your reply.
I need the Top 3 Products sold for every sales Person.
I do not know dax too well though so any suggestions would help.
Kind Regards,
Charmaine
My advise would be to use the Query Editor to reshape the data in a format that makes it much easier to achieve your objective. Instead of:
Name Product 1 Product 2 Salesman 1 200 300 Salesman 2 20 450
you would want:
Name Product Amount Salesman 1 Product 1 200
Salesman 1 Product 2 300
Salesman 2 Product 1 20
Salesman 2 Product 2 450
You can use "Unpivot Column" functionality in the Query editor to achieve this. Once you have the data in this format you can use the DAX TOPN function.
- charmainer9 years ago
Helper III
Hi Thanks for that.
I have tried to unpivot ... but i have duplicate values in the real data ( i have just given you a sample) .
Will get back to you with what i have come back with. i might change the real data and upload it to see how to over come the dupliecat values.
Kind Regards
Charmaine
- charmainer9 years ago
Helper III
Hi,
Back to my top 3 with new version of Matrix
i have upgraded to the new version of BI desktop (sep 2017).
With better sample data,
I have used the latest matrix feature which allows to show columns as rows.
attached pic.
The final list is i want the above to only list the TOP 3 vlaues and Ranks per student( as for each student only list the underlined)
in the Matrix above or
listed like below
Studnet ID Ranked 1 Ranked 2 Ranked 3 567 Judgement Rank Honesty Rank Humanity Rank 566 Leadership Rank Humor Rank Fairness Rank Any suggestions ?