Forum Discussion

insandur's avatar
insandur
Icon for Helper II rankHelper II
3 years ago
Solved

Create a column based Rank measure.

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.
ProductTop Cat( Required column)RankQty
'5043top101561
'4893top102366
'5123top103332
'7163top104261
'7183top105225
'7203top105225
'3592top107216
'3612top107216
'3631top107216
'7142top107216
'3523remaining11189
'3563remaining11189
'3603remaining11189
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    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.

2 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    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.