Forum Discussion

twintrbl's avatar
twintrbl
Icon for Advocate I rankAdvocate I
7 years ago
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...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    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's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

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] ) )
)
twintrbl's avatar
twintrbl
Icon for Advocate I rankAdvocate I
7 years ago

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!