Forum Discussion

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
8 years ago
Solved

Top 10 with a measure

Hello,   I have a report where view sales volume by supplier. In my visualisation i want to only show the top 10 suppliers.    The problem is that sales volume is a measure, created by adding two...
Need Help
  • tex628's avatar
    tex628
    8 years ago

    Well i managed to solve part of the issue. A normal Rankx(ALL(Table[Column]);[Measure]) managed to give proper ranking values to all measurement values. Now the issue is that when i apply external filters the ALL() method results in the ranking ignore the current filter. 

     

    This results in the remaining objects having ranks something like; 1,4,6,7,9 and therefore when i put a filter to only display rank<11 i get lesss than 10 results.

     

    I can sadly not share the tables due to company policy. I will try to recreate the situation with dummy data.

     

    / Johannes

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

Hi tex628

 

As I understand, you want to show the top 10 suppliers and the top 10 are filtered by the Total sales volume, is this rigth? If so then you can filter your data after making the visualisation itself. 

If possible could you please provide a sample data having the given columns and measures as you have in your tables.

 

Regards,

Rohit