How do I de-refernce a value from the row returned with MAXROW()?

[WillowMobileSys]

Just thinking this must be simpler.

I am cycling through a set of Actions to insert a computed number of Teams. So, I know the number of teams to add and to determine if I have inserted the correct number, I am tracking a Team # value. Once this Team # matches my expected number of team to be inserted, I know I am done.

With each iteration, I want to grab the Team row with the maximum Team # and then simply add 1 to it.

I can get the maximum Team # row like so:

MAXROW("Teams", "Team #", [Challenge] = [_THISROW].[Challenge ID])

This returns a row reference to that Team row. Is there some straight-forward way to dereference the Team # value from row reference?

So far the best I could figure out is that I need to do the below but it seem unnecessarily repetitive.

ANY(SELECT(Teams[Team #], 
     [Team ID] = MAXROW("Teams", "Team #", [Challenge] = [_THISROW].[Challenge ID]))
) + 1