Forum Discussion
Solved
Filtering SUM Value Based on Another Measure
Hi All! i am trying to multiply the amount of days a piece of equipment was on a project by the AVG. cost of that equipment to achieve a total cost of plant on project. the current formula t...
Hi TamlerlovesKant ,
12605 is 2521*5, that is, the total of AVG Plant Cost per Day is multiplied by the total of Assigned Equipment Days.
You can create a new measure to get the results you want.
Measure = SUMX('Equipment List',[Plant Assigned Cost])Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi TamlerlovesKant ,
12605 is 2521*5, that is, the total of AVG Plant Cost per Day is multiplied by the total of Assigned Equipment Days.
You can create a new measure to get the results you want.
Measure = SUMX('Equipment List',[Plant Assigned Cost])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thankyou so much Stephen!