Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

create TOP30 sales for models

hi  want to create a new measure that is presenting the Top 30 of the Netsales by Models. Have Models like MDL1, MDL2, MDL3 etc and then i have net sales per model. But i am interested to see what ...
Need Help
Show and Tell
Tutorial Requests
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    If you want a measure to meet your requirements, you could use TOPN() function.

    https://dax.guide/topn/

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Anonymous ,

 

To rank netsales by Model use the below steps:

Step 1: Take one table and drag Netsales and ModelName. Then Go to Filter Pane --> Visual Level  --> Follow step as per below screen shot:

 

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi Tahreem,

    your solution was already known, but i am looking for a measure which only gives the number of sales of the Top X customers.

    The issue is that i need to compare this number with previous year and that is something your solution will not solve.

    Nevertheless, thanks for helping out!!

    • v-eachen-msft's avatar
      v-eachen-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ,

       

      If you want a measure to meet your requirements, you could use TOPN() function.

      https://dax.guide/topn/