% split with multiple criteria

Hi Phil,

If you wanted the second table to have the same layout as the one you showed (I'm guessing you used a Matrix visual?) you could add a measure which divides the salary for each employee and cost code by the total salary for the employee.  Here's a basic version of a measure which would do that:

Salary as % of Employee Total Salary = DIVIDE(
    SUM(YourTable[Salary]),
    CALCULATE(
        SUM(YourTable[Salary]),
        REMOVEFILTERS(YourTable[Cost Code])
    )
)

You can format the measure as a percentage using the Measure Tools tab in the ribbon:

And when you create the matrix you'll see results similar to this:

N.B. I used the following mock data: