Trying to Sum values for left column (not distinct)

[Anonymous]

This should be simple, but taking me way too long to find DAX formula for total hours by employee: I have a table with employee hrs charged to different overhead job numbers. I want to create a percentage in PwrBI table (or Matrix) that is Employee hrs charged to Job A / Total Hrs charged on all jobs by employee.  The table columns I'm creating on canvas has Emp#, Job (can be mutliple jobs for a given employee), then Hrs charged to Job, then Total Hrs charged to all jobs, then finally Percent of hrs charged to Job / Total employee hrs.  Note: if there are two lines with same job for given employee (e.g. charged same job on different days), power bi context is summing hrs for same job using measure JobHrs = Calculate (Sum(table[Hours]).  But I don't know  how to get the Total Hrs charged by employee (on all jobsubs) to work in this filter context.  Thanks for any suggestions.  Jeff

Emp #	Job	Job Hrs	Total Emp Hrs	Percent job/Total
123	ABC	2	5	40%
123	DEF	3	5	60%
345	GHI	6	6	100%

[parry2k · Accepted solution]

@Anonymous try this

Base Hrs = SUM ( Table[Hrs] )

% of total  = 
DIviDE ( [Base Hrs], CALCULATE ( [Base Hrs], ALLEXCEPT ( Table, Table[Job Id] ) ) )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡