Difference between two columns selected by slicer in matrix

Hi Anonymous 

There are some workarounds:

 

As tested, we can create two seperate tables which have no relationship with your table.

slicer1 = VALUES(Sheet6[Campaign])

slicer2 = VALUES(Sheet6[Campaign])

Then create measures in your table

Measure =
VAR r_v =
    CALCULATE (
        SUM ( Sheet6[value] ),
        FILTER (
            Sheet6,
            Sheet6[Campaign] = SELECTEDVALUE ( slicer1[Campaign] )
                || Sheet6[Campaign] = SELECTEDVALUE ( slicer2[Campaign] )
        )
    )
RETURN
    IF (
        HASONEVALUE ( Sheet6[Campaign] ),
        r_v,
        CALCULATE (
            SUM ( Sheet6[value] ),
            FILTER ( Sheet6, Sheet6[Campaign] = SELECTEDVALUE ( slicer1[Campaign] ) )
        )
            - CALCULATE (
                SUM ( Sheet6[value] ),
                FILTER ( Sheet6, Sheet6[Campaign] = SELECTEDVALUE ( slicer2[Campaign] ) )
            )
    )

 

or create three measures and add them in the matrix

company1 = CALCULATE(SUM(Sheet6[value]),FILTER(Sheet6,Sheet6[Campaign]=SELECTEDVALUE(slicer1[Campaign])))

company2 = CALCULATE(SUM(Sheet6[value]),FILTER(Sheet6,Sheet6[Campaign]=SELECTEDVALUE(slicer2[Campaign])))

delta = [company1]-[company2]