Forum Discussion

croberts21's avatar
croberts21
Continued Contributor
3 years ago

PBI will not sum hours correctly

I have PBI Desktop v March 2023. I connect to a Postgresql v9.6.17 database.    I have 2 tables, Jobcost with fields like esthours (which is estimated hours), StartDate and Empid. I have another ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  croberts21 ,

You can try the following dax:

Measure 2 =
var _id=
MAXX(
    FILTER(ALL('Employee'),'Employee'[firstname]=MAX('Employee'[firstname])),[Empid])
return
SUMX( FILTER(ALLSELECTED(JobCost),'JobCost'[Empid]=_id,'JobCost'[startDate])),[esthours])

 

Best Regards,

Liu Yang

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

  • croberts21's avatar
    croberts21
    Continued Contributor
    3 years ago

    I put the measure on Jobcost and I got this error: