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
admin11
Memorable Member
Memorable Member

How to filter only Top 10 sales by invoice ?

Hi All

i have create a table which list sales by invoice number , the amount sort from high to low. now the total listing have 99 , i like to display Top 10 , i have try to using filter panel , by add customer name , and select top 10 and i insert the SALES_ at value , it does not work. Hope some one can advise where go wrong ?

admin11_0-1619245610828.png

https://www.dropbox.com/s/42vai8o2ogir0j2/PBT_V2021_400%20SI_TI.pbix?dl=0

my PBI file

 

Paul

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @admin11 

I think there are two filters in the visualization.

Invoice number and Customer name.

I think you are already seeing only the top 10 customers, but most of them has more than one invoice...

If you pull out the invoice number column, then TOP N visual will work.

 

If you want to see top 10 list by customer and invoice number, please try the below.

Customer Name Column + inv column / and pull out your SALES_ measure and put in the below new measure.

 

sales top 10 show =
SUMX (
KEEPFILTERS (
TOPN ( 10, ALLSELECTED ( SALES[Customer Name], SALES[inv] ), [SALES_], DESC )
),
[SALES_]
)

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi, @admin11 

I think there are two filters in the visualization.

Invoice number and Customer name.

I think you are already seeing only the top 10 customers, but most of them has more than one invoice...

If you pull out the invoice number column, then TOP N visual will work.

 

If you want to see top 10 list by customer and invoice number, please try the below.

Customer Name Column + inv column / and pull out your SALES_ measure and put in the below new measure.

 

sales top 10 show =
SUMX (
KEEPFILTERS (
TOPN ( 10, ALLSELECTED ( SALES[Customer Name], SALES[inv] ), [SALES_], DESC )
),
[SALES_]
)

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


@Jihwan_Kim 

Thank you very much it work fine. 

Paul

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.