Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
insandur
Helper I
Helper I

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
1 ACCEPTED SOLUTION
Mahesh0016
Super User
Super User

@insandur 

Mahesh0016_0-1674042833981.png

 

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.

View solution in original post

2 REPLIES 2
FreemanZ
Super User
Super User

hi @insandur 

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

Mahesh0016
Super User
Super User

@insandur 

Mahesh0016_0-1674042833981.png

 

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors