RANK BY FIGURES AND GROUPS

[Anonymous]

   

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

[v-lili6-msft · Accepted solution]

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:

Best Regards,

Lin

[Anonymous]

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

Reg ,
Pooja

[Anonymous]

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 venkates

[Anonymous]

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

@Anonymous Try with this....

[Anonymous]

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

[v-lili6-msft]

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

[Anonymous]

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]

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]

Hello ,

Is it possible in power bi.???

Please reply fast if you know 

Reg ,
Pooja 

[v-lili6-msft]

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