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 Sta...
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
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