Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    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's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Sorry,

 

Had an additional separator. Try this

Actual Cost = SUMX(ADDCOLUMNS('Timesheet CC',"ActualCost",[Actual Hrs]*MAX('Timesheet CC'[Rate])), [ActualCost])
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I tried it also not working same output as my original one.

Red circle is this formula

Actual Cost CC Test = SUMX(ADDCOLUMNS('Timesheet CC',"ActualCost",[Actual Hrs]*MAX('Timesheet CC'[Rate])), [ActualCost])

 

Appreciate your help thanks!