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.

Thanks
Mike
trans_B.xlsx
mikes6058Asked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Does this help?
Rank:=RANKX(ALL(transactions),[sales total])

Open in new window

0
 
mikes6058Author Commented:
Afraid not Neeraj
0
 
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

0
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.

All Courses

From novice to tech pro — start learning today.