Top N values based on the total count in matrix

nish18_1990 - then you have NO OPTION other than to use a Table visual (not a Matrix). It cannot be a Matrix because a Matrix does not supply the Row context for Sub Category that is needed for the rank. 

 

If you want to break ties by Sub Category YOU NEED TO USE A TABLE. 

 

I have attached a final version of this file. Page 1 has the measure Rank 2 which uses the DAX below to rank in the following order:

 

1. Count of Quantity

2. Sum of sales (to break any ties above)

3. Sub Category A-Z (to further break ties from above)

4. Country A-Z (to break the final ties)

 

VAR _rank =
    RANK (
        DENSE,
        ALLSELECTED ( 'Table'[Sub Category], 'Table'[country] ),
        ORDERBY (
            CALCULATE ( COUNT ( 'Table'[Quantity Q2] ) ), DESC,
            CALCULATE ( SUM ( 'Table'[Sales] ) ), DESC,
            'Table'[Sub Category], ASC,
            'Table'[country], ASC
        ),
        LAST
    )
RETURN
    IF ( _rank <= [Parameter Value], _rank )

 

The table also contains two measures for Count of QTY and Sum of Sales that contain logic to return blank when the rank returns blank. This happens when the parameter value is set to show only a certain number of results. - Which has been your requirement all along, and can only be achieved using a TABLE. 

 

I've now provided this solution multiple times and fine tuned it as much as I can, I'd appreciate it if you could mark it as the solution. 

 

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!