Assistance with a formula

[EZimmet]

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 

[Anonymous · Accepted solution]

Hi @EZimmet ,
Based on your description, and because I couldn't determine the composition of your data and the connections between them, I created some test data

Create measures

Rack Threshold Total Watts = SUM(_Asset[Power Capacity Threshold])

Devices in Rack Total Watts = SUM(_Asset[Power Capacity Defined])

Power Till Threshold Reached = [Rack Threshold Total Watts] - [Devices in Rack Total Watts]

Final output

If the above methods do not meet your needs, you can provide example data or pbix files so that we can help you faster.

Best regards,
Albert He

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

[EZimmet]

Looks like we found a bad value in the DB - after removing it all is working  - TY for your assistance