Assistance with a formula

I know this one shouldn’t be rocket science it’s all me.

I’m pulling Power information on a Datacenter Rack

• Rack Max Power Threshold
• Devices within the Rack Max Power used
• Then need the Difference between the two

-----------------------------------------

DAX

A.  Rack Threshold Total Watts = '_Asset'[Power Capacity Threshold]   -  Pulls correct data

B.  Devices in Rack Total Watts = '_Asset'[Power Capacity Defined]       - Needs to Sum field for Total 

C.  Power Till Threshold Reached = [Rack Threshold Total Watts] – [Devices in Rack Total Watts ]  - Need difference between A & B

------------------------------------------

- A - Left Image is correct

- B - Middle image I have the Sum turned on for the view If I remove the field ID  I'll still get multible lines as different devices have different Power usage just need the Total

- C - Right image should only show the difference