• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 130
  • Last Modified:

RANK X - Rank products by revenues - Powerpivot (DAX solutions only)

Attached is a spreadsheet containing a sales transactions table. On the sales by part sheet you will see I have created a simple pivot table from a PowerPivot model. I would like to create a measure that will rank the part codes by revenue.

Can anyone help me with a measure and explain the basic logic behind it.

I am novice with DAX but would like to learn more so the logic helps.

  • 2
1 Solution
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Does this help?
Rank:=RANKX(ALL(transactions),[sales total])

Open in new window

mikes6058Author Commented:
Afraid not Neeraj
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Hi Mike,

Please create a measure with the following formula and see if that resolves your issue of ranking the Sales by the Part Code.

=RANKX(ALL(transactions[partcode]),[sales total])

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now