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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

RANK BY FIGURES AND GROUPS

RANK.PNG   

 

Hello ,
I have different lot no column on that I want to grouping and based on tender rate decending order ranking .

If you can see in table blue color same tender rate have same rank  (18).

If  we cahnge lot no then rank should be dynamicaly change according to tender rate.

thanks in advance

reg ,
Pooja

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi, @Anonymous

You could use RANKX Function to create a column by this formula as below:

 

Rank = RANKX(FILTER('Table','Table'[Lot No]=EARLIER('Table'[Lot No])),'Table'[Tender Rate],,DESC,Dense)

 

 

Note:

Skip The next rank value, after a tie, is the rank value of the tie plus the count of tied values. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 16 (11 + 5).

This is the default value when ties parameter is omitted.
Dense The next rank value, after a tie, is the next rank value. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 12.

 

Result:

1.JPG

Best Regards,

Lin

 

 

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10
v-lili6-msft
Community Support
Community Support

hi, @Anonymous

You could use RANKX Function to create a column by this formula as below:

 

Rank = RANKX(FILTER('Table','Table'[Lot No]=EARLIER('Table'[Lot No])),'Table'[Tender Rate],,DESC,Dense)

 

 

Note:

Skip The next rank value, after a tie, is the rank value of the tie plus the count of tied values. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 16 (11 + 5).

This is the default value when ties parameter is omitted.
Dense The next rank value, after a tie, is the next rank value. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 12.

 

Result:

1.JPG

Best Regards,

Lin

 

 

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@v-lili6-msftThank you !!!   Its work...

Reg ,
Pooja

Anonymous
Not applicable

hi @Anonymous 

 

i am trying to find rank, by using RankX function in powerbi

but it's not working can please see it once

 

Thanks and Regards.

Bobbala Naveen venkatesCapture.PNG

Anonymous
Not applicable

 

Rank = RANKX(FILTER('Table','Table'[Lot No]=EARLIER('Table'[Lot No])),'Table'[Tender Rate],,DESC,Dense)

@Anonymous Try with this....

 

Anonymous
Not applicable

Hi @Anonymous  @v-lili6-msft ,

 

i am trying find out the rank by using Riskrating column in powerBI, But it's not working for me.

my data numbers are repeated, So rank also repeated in powerbi. i want rank also incrementing,

please once see it my query.

 

thanks and regards

Bobbala Naveen

 

Capture2.PNGInkedCapture_LI.jpg

hi, @Anonymous 

Rank = RANKX(FILTER('Table','Table'[Lot No]=EARLIER('Table'[Lot No])),'Table'[Tender Rate],,DESC,Dense)

This formula should work well. Do you mean that the Label even for each CountryName have the same Riskating needs to do a rank calculation?

So what the logic for label have the same riskrating to do a rank?

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-lili6-msft  @Anonymous 

 

please send me Dax funtion by using RankX.

 

I have data like this,

 

CountryName              Label                          Riskrating    
Afghanistan Brand       Management               15                

Afghanistan Brand       Business continuity      20                

Afghanistan Brand       Management1             20                

Afghanistan Brand       Management2             12                

Afghanistan Brand       Management3             12                

Albania                        management                20                

Albania                        management1              20                

Albania                        management 2             20                

Bangladesh                 Management                56                
Bangladesh                 Management1              56       

 

i want rank like this

 

CountryName              Label                          Riskrating     rank
Afghanistan Brand       Management               15                3

Afghanistan Brand       Business continuity      20                1

Afghanistan Brand       Management1             20                2

Afghanistan Brand       Management2             12                4

Afghanistan Brand       Management3             12                5

Albania                        management                20                1

Albania                        management1              20                2

Albania                        management 2             20                3

Bangladesh                 Management                56                1
Bangladesh                 Management1              56                2

Anonymous
Not applicable

hi @v-lili6-msft 

 

Actualy i want display Rank by using Riskrating with in the one country. But i have some repeated numbers in riskrating column, 

So, That time rank also repeating in powerbi. Please send me dax function by using rankx.

 

My Data:-

 

CountryName              Label                          Riskrating     
Afghanistan Brand       Management               15               

Afghanistan Brand       Business continuity      20              

Afghanistan Brand       Management1             20               

Afghanistan Brand       Management2             12             

Albania                        management                20                

Albania                        management1              20               

Albania                        management 2             20                

Bangladesh                 Management                56                
Bangladesh                 Management1              56       

 

I want Output Like this:-

 

CountryName              Label                          Riskrating     rank
Afghanistan Brand       Management               15                  3

Afghanistan Brand       Business continuity      20                  1

Afghanistan Brand       Management1             20                  2

Afghanistan Brand       Management2             12                  4

Afghanistan Brand       Management3             12                  5

Albania                        management                20                  1

Albania                        management1              20                  2

Albania                        management 2             20                  3

Bangladesh                 Management                56                  1
Bangladesh                 Management1              56                  2

Anonymous
Not applicable

Hello ,

Is it possible in power bi.???


Please reply fast if you know 

Reg ,
Pooja 

hi, @Anonymous

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.