Forum Discussion

hung0902's avatar
hung0902
New Member
9 years ago
Solved

Rank - top 10

I have a report that shows 2 column, each of which is from 2 different tables - Product Name and Sales Quantity. How do I set a filter to show only the top 10/bottom 10 product based on quantity?

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    It's in the filter well. You should see Advanced Filtering, Basic Filtering, and Top N.

     

    At that point, you just drag in the measure you want the Top N to run off of, such as "Sum of SalesQuantity".

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    It's in the filter well. You should see Advanced Filtering, Basic Filtering, and Top N.

     

    At that point, you just drag in the measure you want the Top N to run off of, such as "Sum of SalesQuantity".

  • h2danilo's avatar
    h2danilo
    Helper I
    7 years ago

    I have a table with 20 product groups, and I would like to show  just the top 5 groups that sold the most. Anyone could help me?

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      What result do you get when you follow the solution auggested above.

      • h2danilo's avatar
        h2danilo
        Helper I
        7 years ago

        Hi, 

         

        I got it!

         

        I used the following code:

        RANK = 
CALCULATE
(
RANKX
(
ALLSELECTED(DadosConsolidados[Grupo]);
DadosConsolidados[TotalGeralVendaLiquida]
);
ALL
(
DadosConsolidados[TIPO_CLIENTE])
)