Forum Discussion

Kai23's avatar
Kai23
New Member
2 years ago

Top by Top Matrix Table in PowerBI

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:

 

 

Need Help

4 Replies

  • CoreyP's avatar
    CoreyP
    Solution Sage
    2 years ago

    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. 

    • Kai23's avatar
      Kai23
      New Member
      2 years ago

      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.

      Rank = RANKX(Sheet1,SUM(Sheet1[Quantity]),,DESC,DENSE)

       

      • CoreyP's avatar
        CoreyP
        Solution Sage
        2 years ago

        You need to remove context, use ALL().