Currently I have to rely on "sales by sku" to know which is the top n sellers by each month.
I would like to create a measure that shows the sku of top 1 seller (either by unit or by sales) and adding it to my "main dashboard", another measure column for 2nd best, and another for 3rd best and so on.
Any ideas how to achieve that?
Total Sales=SUM( Sales)
Total Cost= SUMX(Sales,units_order]* price)
Total Profit= Total sales- Total Costs
SKU Rank= RANKX(ALL( SKU),Total Profit, , Desc)
Top 5 Sku= IF (isfiltered(sku),IF (SKU Rank <=5, Total Profit, Blank() ),CALCULATE (total profit, TOPN (5, Values (SKU),total profit))
Thanks for replying.
But, the measure I'm looking for is returning the sku name of the product rather than number.
In the example dataset should looks like this:
|month||unit order||sale||1st sku||2nd sku|
Sorry if I didn;t clearify myself.