Forum Discussion

joschultz's avatar
joschultz
Icon for Advocate II rankAdvocate II
11 years ago
Solved

Top 15 in a report

What is the easiest way to show just the top 15 items in a report?  Example is I want to show the top 15 products in sales for the day.  I will have hundreds of products in the data but only want the...
Need Help
  • kcantor's avatar
    kcantor
    10 years ago

    I use the Rank X measure for my products in the filter area of the visual (or whole page as needed). Then, when I add other values, there is nothing to break. I don't put the Rank X in the visual, I just use it as a filter for the page/report. In fact, I usually fill in all other information then apply it last to pull up my top 25.

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
10 years ago

Add the RankX measure to your data set.   For my RankX I chose to  Rank my sales performance based upon the YOY dollar variance using: Rank Top $ Variance TotalSales = RANKX(ALL(SalesPerformance[MfgName]),[$ Variance TotalSales])  This is my measure using my data measure and column names.  this returns a value as for where the manufacture falls in the list of all manufacturers. For example, our top performer is 1. Our worst performer is 504 or such.

When I create my report, I add in the information that I want to see without the RankX measure. Then, when the report is ready, I drag my RankX measure into th report filter area. Since i want the top 25 performers, I choose the value to be "less than" and fill in 26 and apply. This reduces the report down to the top 25 performers and is done completely by stand alone measures and built in filter systems.

Please note that I have shared my actual measure specific to my data. You may need to make changes in order to use it for your report.

ikkew's avatar
ikkew
Icon for Advocate I rankAdvocate I
8 years ago

I've tried this but can't seem to make it work... would really appreciate it if you could take a look.

 

I have an Article table containing a Description field and a ArticleMonth table containing a Sales field.
I want to see the top 200 articles based on sales.

 

It seems like I have to use RANKX in a similar way but I can't seem to display the data correctly.
Top 200 Articles = RANKX( ALL( Article[Description] ), ArticleMonth[Sales] ) OR
Top 200 Articles = RANKX( ALL( Article[Description] ), CALCULATE( SUM( ArticleMonth[Sales] ) ) )

Trying to display the earlier mentioned fields combined with some others in a Matrix view.

What could I be doing wrong?