Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hung0902
New Member

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

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

4 REPLIES 4
h2danilo
Helper I
Helper I

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

 

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi, 

 

I got it!

 

I used the following code:

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.