Return a value from a specific row

Hi Bigascon,

If you need it as a calculated column this should work. I am not sure if it is the fastest way. Maybe somebody has a faster way:)

Usercount max progress =
//calculate maxprogress for challengeid
VAR MAXPROGRESS =
    CALCULATE (
        MAX ( 'example'[Progress] ),
        FILTER (
            'example',
            'example'[ChallengeID] = EARLIER ( 'example'[ChallengeID] )
        )
    ) //calculate usercount for row that contains maxprogress (highest if 2 rows are equal in progress  
VAR USERCOUNT =
    CALCULATE (
        MAXX (
            FILTER ( 'example', 'example'[Progress] = MAXPROGRESS ),
            'example'[UserCount]
        ),
        ALLEXCEPT ( 'example', 'example'[ChallengeID] )
    )
RETURN
    USERCOUNT