Forum Discussion
Solved
Rank with two categories
I'm trying to rank our Vendors by their average survey scores, but I need it ranked not just by the Vendor, but by the Vendor and the State. Over-simplified example: I have tried all ki...
Hello twintrbl
You can feed more than one column into your ALL statement which will give you the combined list to rank over. Give this a try.
Ranking = RANKX ( ALL ( 'Dispatch'[Vendor], 'Dispatch'[State] ), CALCULATE ( AVERAGE ( Survey[Rating] ) ) )
Hello twintrbl
You can feed more than one column into your ALL statement which will give you the combined list to rank over. Give this a try.
Ranking =
RANKX (
ALL ( 'Dispatch'[Vendor], 'Dispatch'[State] ),
CALCULATE ( AVERAGE ( Survey[Rating] ) )
)
jdbuchanan71 Thank you! That worked! I knew it had to be something simple. I just never saw any examples with two columns in the ALL statement. Thank you for taking the time to reply!