Column with one value per group

Hi, otter1 

You can try the following methods.

Column = 
Var _minCat4=CALCULATE ( MIN ( 'Table'[Category 4] ),
            ALLEXCEPT ( 'Table', 'Table'[Category 1] ) ) 
Return
IF ( [Category 4] = _minCat4,
    CALCULATE ( MAX ( 'Table'[Sales] ),
        FILTER ('Table',
            [Category 1] = EARLIER ( 'Table'[Category 1] )
            && [Category 2] = EARLIER ( 'Table'[Category 2] )
            && [Category 3] = EARLIER ( 'Table'[Category 3] )
        )
    ),
    BLANK ()
)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.