cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ThiagoDuarte
Frequent Visitor

Rank with groups and duplicates

Hello guys,

 

I need some help with a rank column

 

This is what I have:

ThiagoDuarte_0-1645039495735.png

I need to rank rpr column inside every rpf value

 

rpf is a report id and every rpr is a sample inside the report. I need to sort the samples (first, second, third ..... ). the blanks should be sample 0

 

I need to reach this result:

 

ThiagoDuarte_1-1645039746898.png

 

For every rpf value the rank should restart following the same logic:

rpr = blank -> 0

rank by rpr ascending

 

Could someone pleasae help me?

 

Thanks,

Thiago Duarte

 

 

 

 

 

 

1 ACCEPTED SOLUTION
tomfox
Super User
Super User

Hi @ThiagoDuarte ,

How about this:

tomfox_0-1645041912943.png

 

I used the following code to create a calculated column:

TomsRankColumn = 
RANKX ( 
    FILTER ( Table, Table[rpf] = EARLIER ( Table[rpf] ) ), 
    Table14[rpr],
    ,
    ASC, 
    DENSE 
) - 1

 

Does this work for you? 🙂

 

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
tomfox
Super User
Super User

Hi @ThiagoDuarte ,

How about this:

tomfox_0-1645041912943.png

 

I used the following code to create a calculated column:

TomsRankColumn = 
RANKX ( 
    FILTER ( Table, Table[rpf] = EARLIER ( Table[rpf] ) ), 
    Table14[rpr],
    ,
    ASC, 
    DENSE 
) - 1

 

Does this work for you? 🙂

 

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors