Changing the reference data in a table with a slicer

[Alexxx]

Car	Mass	Delta Mass
VW Beetle	2000kg	0
Q7	2500kg	+500kg
BMW 3 series	2200kg	+200kg

Hello all,

I have a table like the one above. The delta Mass is now calculated using the VW Beetle as a reference.

Now I want to select the reference Car by picking it from a list (e.g. from a slicer). 

So if I pick the Q7 for example it should look like this:

Car	Mass	Delta Mass
VW Beetle	2000kg	-500kg
Q7	2500kg	0
BMW 3 series	2200kg	-300kg

How is that done in Power BI?

Thanks for helping.

Alex

[Alexxx]

@lbendlin Thank you very much!!! Works like a charm.

[lbendlin · Accepted solution]

Wowowo, easy on the sample data!  I have adjusted it to something more realistic.

Here's one possible implementation.