Retrieving Column Values When a Measure Reaches Its Maximum

Hi mh20221111 

You can create a measure.

Diff =
VAR a =
    SUMMARIZE (
        ALLSELECTED ( table ),
        [Category1],
        [Size],
        [Amount1],
        "Max0", [Measure0]
    )
VAR b =
    MAXX (
        TOPN (
            1,
            FILTER ( a, [Category1] IN VALUES ( table[Category1] ) ),
            [Max0], DESC
        ),
        [Amount1]
    )
RETURN
    SUM ( table[Amount1] ) - b

Best Regards!

Yolo Zhu

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