Forum Discussion
Add value from a related table to a sum
I have a gauge showing sum of hours from [Project]Hours.
To this sum, however, I'd like to add the value from related [Employee]InitValue but can't figure out how to create that calculation.
I guess I have to create a calculated field or measure, but struggle to find out how. Help greatly appreciated.
Hi Anonymous,
While you may not be able to use RELATED function on the one side of the many to one relationship, I believe you can do something like
MY MEASURE = SUM ( 'Project'[Hours] ) + SUM ( 'Employee'[InitValue] )
4 Replies
dramusContinued Contributor
If the fields really are related then you should be able to create a measure of sum(project[hours])+related(employee[InitValue])
I did try that, but the function does not allow me to use relate in a measure field in Projects (either does not exist or doesn't have a relationship to any table in the current context). Projects DOES have a many to one relationship to Employees.
But if this had worked, wouldn't that function add the init value to each of the project hour records? I want to sum the project hour records and then add the init value once on top on the sum.
- danextian
Super User
Hi Anonymous,
While you may not be able to use RELATED function on the one side of the many to one relationship, I believe you can do something like
MY MEASURE = SUM ( 'Project'[Hours] ) + SUM ( 'Employee'[InitValue] )