Forum Discussion
Ranking with multiple Fields
Help with below Ranking.
I want to create a measure RANK using the _All_ as my criterion and group fields will be Zone and State, however only the value gotten from Zone will apply to all the State.
So the outcome of the ranking in Table B is applied to Table A regardless of whatever table A result is.
Table A
| Zone | State | _All_ | Rank |
| A | C0000587112 | 99.71 | 1 |
| A | C0000586271 | 99.18 | 1 |
| A | C0000585676 | 99.73 | 1 |
| B | C0000585027 | 99.68 | 2 |
| B | C0000585028 | 100.68 | 2 |
| B | C0000585029 | 101.68 | 2 |
| C | C0000585030 | 102.68 | 3 |
| C | C0000585031 | 103.68 | 3 |
| C | C0000585032 | 104.68 | 3 |
Table B
| Zone | _All_ | Rank |
| A | 99.7 | 1 |
| B | 99.9 | 2 |
| C | 100 | 3 |
2 Replies
Anonymous , Not very clear. If _All_ is measure then
Rankx(Allselected(Table[Zone], _All_,,asc,dense)
Should work
Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=25627s
Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo
