Reply
Frequent Visitor
Posts: 4
Registered: ‎07-10-2017
Accepted Solution

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


Accepted Solutions
Established Member
Posts: 136
Registered: ‎11-20-2015

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".

View solution in original post


All Replies
Established Member
Posts: 136
Registered: ‎11-20-2015

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".

Frequent Visitor
Posts: 7
Registered: ‎09-14-2018

Re: Rank - top 10

[ Edited ]

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
Posts: 3,943
Registered: ‎01-14-2017

Re: Rank - top 10

Hi,

 

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

Frequent Visitor
Posts: 7
Registered: ‎09-14-2018

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])
)