Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, I have been trying to create a Top by Top Matrix table in PowerBI, but I'm not sure how i can do it.
(1) I am unable to use more than 1 top n filter in a matrix table. In the screenshot, I have already applied top 10 to the columns, but I can't add another one for the rows.
(2) I can't sort the columns by the grand total, it is currently alphabetically sorted.
This is the expected table I am looking for:
You can use RANKX to rank each of the column values. Then sort the column field by this new rank column, then it should sort them correctly and you won't need a top N for columns, only for the rows.
Hi CoreyP, Thank you for the suggestion, I tried to use RankX but I'm not familiar with it, and the rank is showing 1 for all of them, and I can't figure out why its not working.
You need to remove context, use ALL().
Do you mean I should do this?
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |