cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Anonymous
Not applicable

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
Anonymous
Not applicable

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

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 317 members 3,391 guests