Create a column based Rank measure.

[insandur]

Hi,

I have a product coulumn with the Qty and also created a Rank meausre.

Rank = RANKX(ALL(Data[Product]),Data[Total SKU STK],,DESC,Skip)

now i want a column in data which shows if (Rank <11 "Top10 items", "remaining" ) as shown in column2 below.

i want to use this column in a gage Visual as it takes only column not the measure.

Product	Top Cat( Required column)	Rank	Qty
'5043	top10	1	561
'4893	top10	2	366
'5123	top10	3	332
'7163	top10	4	261
'7183	top10	5	225
'7203	top10	5	225
'3592	top10	7	216
'3612	top10	7	216
'3631	top10	7	216
'7142	top10	7	216
'3523	remaining	11	189
'3563	remaining	11	189
'3603	remaining	11	189

[FreemanZ]

hi @insandur 

it seems you have all you want. what do you expect?

[Mahesh0016 · Accepted solution]

@insandur 

New Column :
Top Cat =

 VAR Rankk =RANKX(ALL('Product'[Product],'Product'[Qty]),'Product'[Total Qty],,DESC,Skip)

 RETURN

 IF(Rankk<11,"Top10 items", "remaining")

@insandur If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.