Forum Discussion
Calculated Column Rank for Page Level Filter
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 |
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.
2 Replies
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.
Thank you very much! (I took me weeks and many complicated formulas, and I could not get to this result.)
Thank you ! :smileyvery-happy:
