Matrix Table Variance -> selected value

Hi Anonymous ,

As lbendlin  says, there's no guarantee that your team will only choose two values, but I've created a simple example that will only calculate the difference between two values even if someone on your team chooses 3 values.

Please refer to.

Create 2 columns.

Measure =
VAR _MAX =
    MAXX ( ALLSELECTED ( 'Table' ), 'Table'[region] )
VAR _MIN =
    MINX ( ALLSELECTED ( 'Table' ), 'Table'[region] )
VAR _MAXVAL =
    CALCULATE (
        SUM ( 'Table'[value] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[date] = SELECTEDVALUE ( 'Table'[date] )
                && 'Table'[region] = _MAX
        )
    )
VAR _MINVAL =
    CALCULATE (
        SUM ( 'Table'[value] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[date] = SELECTEDVALUE ( 'Table'[date] )
                && 'Table'[region] = _MIN
        )
    )
VAR _RE = _MAXVAL - _MINVAL
RETURN
    _RE

Measure 2 = 
IF(HASONEVALUE('Table'[region]),MAX('Table'[value]),[Measure])

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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