Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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.
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |