Unable to create relationship

Hi JustDavid​ 

try attached pbix.

Salary Paid by LOB =
SUMX (
    VALUES ( dimLOB[LOB] ),
    VAR CurrentLOB = dimLOB[LOB]
    VAR EmployeesInLOB =
        CALCULATETABLE (
            VALUES ( dimEmployee[EmpName] ),
            LOB[LOB] = CurrentLOB
        )
    VAR LOBResult =
        SUMX (
            EmployeesInLOB,
            VAR CurrentEmp = dimEmployee[EmpName]

            -- Split hours: everything except O/T 1.5, and O/T 1.5 separately
            VAR RegularHours =
                CALCULATE (
                    SUM ( Payroll[Hours] ),
                    Payroll[EmpName] = CurrentEmp,
                    Payroll[Hour Types] <> "O/T 1.5"
                )
            VAR OT15Hours =
                CALCULATE (
                    SUM ( Payroll[Hours] ),
                    Payroll[EmpName] = CurrentEmp,
                    Payroll[Hour Types] = "O/T 1.5"
                )
            VAR EffectiveHours = RegularHours + ( OT15Hours * 1.5 )

            VAR RateThisMonth =
                CALCULATE (
                    AVERAGE ( Timesheets[Hourly Rate] ),
                    Timesheets[EmpName] = CurrentEmp
                )

            VAR PayBeforeAllocation = EffectiveHours * RateThisMonth

            VAR EmpAllocation =
                CALCULATE (
                    SUM ( LOB[Allocation] ),
                    LOB[EmpName] = CurrentEmp,
                    LOB[LOB] = CurrentLOB
                )

            RETURN
                PayBeforeAllocation * EmpAllocation
        )
    RETURN
        LOBResult
)

please give kudos or mark it as solution once resolved.

Regards,

praful