Ranking with multiple Fields

[Anonymous]

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

[amitchandak]

@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

[Anonymous]

I try that already it doesnt work. What i want to achieve is what is displayed on Table A. 

It is group by only the Zone regardless of how many fields that is added to the table