Rankx - If tied then rank using another measure

[Qotsa]

Hi,

This measure ranks [Location] based on [Score]->

Rank = RANKX(ALL(Query1[Location]),[Score],,ASC,Dense)

For ties, I need to rank on a second measure [Avg Last 8 Wks Offered]

I have below measure that returns no errors but a 'not enough memory to complete' error message appears.

Rank = RANKX(ALL('Query1'),

RANKX (ALL('Query1'[Location]), 'Query1'[Score])

+ DIVIDE(

RANKX(ALL('Query1'), 'Query1'[Avg Last 8 Wks Offered]),

(COUNTROWS(ALL('Query1')) + 1)

)

, ,ASC )

[Qotsa]

@VijayP 

Got it working with -

Rank = RANKX(ALL('Query1'[Location]),

RANKX (ALL('Query1'[Location]), 'Query1'[Score])

+

RANKX(ALL('Query1'), 'Query1'[Avg Last 8 Wks Offered]) /

(COUNTROWS(ALL('Query1')) + 1)

, ,ASC )

Thks for your input on this.

[VijayP · Accepted solution]

@Qotsa 

If this is solved please mark this as solution Thanks!

[Qotsa]

Wasn't sure on the parenthesis to add so I removed divide and used / instead.

Still getting same memory error message.

Rank = RANKX(ALL('Query1'),

RANKX (ALL('Query1'[Location]), 'Query1'[Score])

+

RANKX(ALL('Query1'), 'Query1'[Avg Last 8 Wks Offered]) /

(COUNTROWS(ALL('Query1')) + 1)

, ,ASC )

[VijayP]

@Qotsa 

Check the Parenthesis with Divide function , the last Parenthesi is missing i think!