AddColumns with Summarize

gpillai99,

Try this solution.

1. Data model:

2. Measures:

Billable Hours = SUM ( LaborHours[Billable Hours] )

Non-Billable Hours = SUM ( LaborHours[Non-Billable Hours] )

Allocated Labor Cost = 
VAR vBaseTable =
    ADDCOLUMNS (
        SUMMARIZE (
            LaborHours,
            Customer[Customer ID],
            Employee[Employee ID],
            Employee[Labor Cost]
        ),
        "@CustomerHours", [Billable Hours] + [Non-Billable Hours]
    )
VAR vEmpHoursTable =
    ADDCOLUMNS (
        vBaseTable,
        "@EmployeeHoursTotal", CALCULATE ( [Billable Hours] + [Non-Billable Hours], ALL ( Customer ) )
    )
VAR vPercentTable =
    ADDCOLUMNS (
        vEmpHoursTable,
        "@Percent", DIVIDE ( [@CustomerHours], [@EmployeeHoursTotal] )
    )
VAR vAllocationTable =
    ADDCOLUMNS ( vPercentTable, "@Allocation", [@Percent] * Employee[Labor Cost] )
VAR vResult =
    SUMX ( vAllocationTable, [@Allocation] )
RETURN
    vResult

3. Create visual using Customer[Customer ID]:

Yes, this is very clear and works perfectly. Thanks!