cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hung0902 Frequent Visitor
Frequent Visitor

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?pyco2.png

1 ACCEPTED SOLUTION

Accepted Solutions
SonnyChilds Established Member
Established Member

Re: Rank - top 10

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

PBIDesktop_2017-07-10_07-48-53.png

 

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 4
SonnyChilds Established Member
Established Member

Re: Rank - top 10

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

PBIDesktop_2017-07-10_07-48-53.png

 

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

h2danilo Frequent Visitor
Frequent Visitor

Re: Rank - top 10

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?

Grupos.png

 

Super User
Super User

Re: Rank - top 10

Hi,

 

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

h2danilo Frequent Visitor
Frequent Visitor

Re: Rank - top 10

Hi, 

 

I got it!

 

I used the following code:

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