Matrix Table Variance -> selected value

[Anonymous]

Hi Team,

I have cretaed matrix table in that I need varience based on selected value from slicer.

APAC and EMEA is there, please advise Difference value, how do I calculate. 

Thanks,

w_Das

[Anonymous]

Hi @lbendlin 
I have two different slicer so they have selecting single value option
Please find the below screenshot.
Slicer1 , slicer 2 
In the table including difference in each FY

[Anonymous]

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.

[lbendlin]

How are you guaranteeing that the report user always chooses exactly two regions?