Forum Discussion
Top 3 values in a row in Table
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.
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 ?