Using a slicer value across a table within a measure

Hi charliep938 ,

Here I suggest you to create an unrelated "Dim Brand Name" table for slicer.

My Sample:

Data model:

Measure:

Average Sold Price = CALCULATE(AVERAGE('Table'[Sold Price]))

Brand Variance (£) = 
VAR _SELECTBRAND =
    SELECTEDVALUE ( 'Dim Brand Name'[Brand Name] )
VAR _SELECTAVG =
    CALCULATE ( [Average Sold Price], 'Table'[Brand Name] = _SELECTBRAND )
RETURN
    [Average Sold Price] - _SELECTAVG

Result is as below.

Best Regards,
Rico Zhou

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