mikes6058
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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])
ASKER