How to filter only Top 10 sales by invoice ?

[admin11]

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 ?

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

my PBI file

Paul

[Jihwan_Kim · Accepted solution]

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

[admin11]

@Jihwan_Kim 

Thank you very much it work fine. 

Paul