Need help with DAX calculation

I am able to calculate accurate values by creating 2 tables but I have few other columns that I need to do the same. Is there a way that I can just include all this in a new column or measure instead of creating 2 tables?

Here is what I did so far:

Creating AssignmentFTE Table

AssignmentFTETable=summarize(EmployeeTable,EmployeeNumber,AssignmentNumber,AssignmentFTE)

I then created another EmployeeFTE table:

EmployeeFTETable=summarize(AssignmentFTETable,EmployeeNumber,"EmployeeFTE",sum(AssignmentFTE)

EmployeeFTE is correctly calculated but is there a way I can do all this without creating tables i.e just placing all this logic in a new column? Appreciate any help.

Thanks,

-Raj