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.