Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Responsive Resident
Responsive Resident

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 table Employee with a field like Empid, firstname, Lastname. Jobcost.empid is connected to Employee.empid in the relationships pane. Empid in both tables is a string with a length of 6.


Here are the tables and fields again.

Jobcost will have many entries per day for each Empid. 





Employee[Empid] (connected to Jobcost[Empid])




I'm trying to make a matrix to sum hours in a given startDate range by employee. PBI should just sum this by Empid but it doesn't in this case. PBI works in other cases in other PBIX files. 


But pbi gives me all hours summed in the table for every employee so all the values for all employees are the same. My sum is in a measure which looks like: 

Est Hours = SUM(JobCost[estcost])
Example incorrect output: 
John Smith    4001
Sally Green    4001
Jim Jones      4001
The esthours should be different for each employee.
I am unable to upload real data at this time. 
Anyone know how to sum by employee? 
EDIT: I'm making some test data which may help you and me. The test data works like it should but my real data does not. So posting test data will not help at this point. I'm not sure why my real data does not work.
Community Support
Community Support

Hi  @croberts21 ,

You can try the following dax:

Measure 2 =
var _id=
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.

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




Post Prodigy
Post Prodigy

This is often the case when no valid relationship exists between tables (DimTable, FactTable).
Can you post a screen with your datamodel relationships of these two tables?
How is the field JobCost[estcost] defined?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors