Forum Discussion
SUMX Function not working calculating per row
Hi PowerBI Experts. I'm working on a POC project. Sumx Function is not working as expected I might be missing some calculations. Table1: timesheetCC table It contains the actual hours, date, Re...
Hi Anonymous ,
When you pick up the MAX at the Actual Cost in the project level you are getting the maximum value for all the lines in that project in this case try to change your measure to:
Actual Cost = SUMX(ADDCOLUMNS('Timesheet CC',"ActualCost",[Actual Hrs])*MAX('Timesheet CC'[Rate])), [ActualCost])Just did this without testing it may need some adjustments.
MFelix
Super User
Super UserHi Anonymous ,
When you pick up the MAX at the Actual Cost in the project level you are getting the maximum value for all the lines in that project in this case try to change your measure to:
Actual Cost = SUMX(ADDCOLUMNS('Timesheet CC',"ActualCost",[Actual Hrs])*MAX('Timesheet CC'[Rate])), [ActualCost])
Just did this without testing it may need some adjustments.