topic Re: Make value scalar, Subtract baseline value from other values. in DAX Commands and Tips

Make value scalar, Subtract baseline value from other values.

emk153 — Thu, 02 May 2024 02:51:50 GMT

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

Re: Make value scalar, Subtract baseline value from other values.

DataNinja777 — Thu, 02 May 2024 03:52:48 GMT

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,

Re: Make value scalar, Subtract baseline value from other values.

emk153 — Thu, 02 May 2024 04:01:17 GMT

you are my hero. thank you so much.