Make value scalar, Subtract baseline value from other values.

[emk153]

Need help with how to unlink baseline value with its associated design strategy.

Avoided Carbon =

   // Grab baseline value
   CALCULATE([Carbon Total], 'LCCA Calculations'[Design Strategy]==SELECTEDVALUE('Z Baseline Key'[Design Strategy]))

   // Subtract other options

   - [Carbon Total]

Currently, this is the output.

This is the desired output. For example: the PV's Avoided Carbon is (Baseline) 261,071 - (Carbon Total) 231,351 = 29,720

[DataNinja777 · Accepted solution]

Hi @emk153 ,

You can achieve your required output in many ways, but one way is as follows:

You can create a [Baseline (all)] measure which ignores filter of Design Strategy field, and deduct [Carbon Total] measure from the Baseline (all) measure.  

I attach the pbix file as an example.  

Best regards,

[emk153]

you are my hero. thank you so much.