Calculated Column Rank for Page Level Filter

[vicpg]

Hi 

I have to create a page for each of our top production losses. In other words, rank the losses from 1 to 5 and then use the ranking to filter at page level. For example, if filtered on rank 1, all the info for the top loss will show.  I can't use a measure for this (measures nog allowed in page level filter). Please assist with the formula for a calculated column to rank the production losses . Thanks in advance.

Reason	Qty
Bubbles	3
Bad breakout	15
Bright spot	12
Fracture test	2
Hole damage	47
Bad breakout	20
Bright spot	5
Fracture test	1
Hole damage	7
Fracture test	16
Hole damage	13
Bad breakout	3
Bright spot	48
Fracture test	21
Hole damage	6

Row Labels	Sum of Qty	Rank
Hole damage	73	1
Bright spot	65	2
Fracture test	40	3
Bad breakout	38	4
Bubbles	3	5

[vrossouw]

Thank you very much!  (I took me weeks and many complicated formulas, and I could not get to this result.) 

Thank you   !   

[ankitpatira · Accepted solution]

@vicpg that is actually easy to do. go to power bi desktop query editor -> Group by Reason column -> Sort by descending -> Add index column which will be your rank column.