The issue I face is that the Top 5/Top 10 slicer does not display the top 5/10 in the matrix as it should as I include more criteria into the Rows in the matrix visualization.
Need your advice on the possible solution on this.
The formula the way you have it only sorts by Material, when you add in the Occasion that is when there is an issue. I will work on a solution, but only have to adjust the RANKX Measure in order to do so. Here is picture of what you have currently setup with your formula.
This works properly if you take out the material name column. Look at picture attached. If you want material name column to be included, will need to add that to the measure. Let me know what you think.