get top title of seller via measures

[shihwenwu]

Hi,

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.

The data structuredashboard overviewselect Augest to check top sellers from "Sales by sku"select JuAuguesto check top sellers from ""Sales by sku

Any ideas how to achieve that?

Thanks~

[edejes2]

Hello @shihwenwu,

Try this,

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))

Regards!

ED

[shihwenwu]

Hi @edejes2

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
7	64	1015	d	e
8	158	2410	d	c

Sorry if I didn;t clearify myself.

Thanks~