Difference between two rows in a matrix (row subdifferences)

Hi mikeoshields ,

Measure can only be placed in the value of the matrix view, and the view you expect cannot be achieved with a matrix.

This can currently be achieved:

Sample data:

Measure:

Difference =
CALCULATE (
    MAX ( 'Table'[Value] ),
    FILTER (
        ALL ( 'Table' ),
        [UCT_CD] = SELECTEDVALUE ( 'Table'[UCT_CD] )
            && [Date] = SELECTEDVALUE ( 'Table'[Date] )
    )
)
    - CALCULATE (
        MIN ( 'Table'[Value] ),
        FILTER (
            ALL ( 'Table' ),
            [UCT_CD] = SELECTEDVALUE ( 'Table'[UCT_CD] )
                && [Date] = SELECTEDVALUE ( 'Table'[Date] )
        )
    )

The result is:

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

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