Forum Discussion
Resolver IAssistance with a formula
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 dataCreate 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 HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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
Resolver ILooks like we found a bad value in the DB - after removing it all is working - TY for your assistance