splitting sales $

Hi FCF 

In addition to  amitchandak 's reply, you need to build a hierachy level table with the percentage of sales support in total.

And then you can build a new table by dax or use merge function in power query editor.

Sample table:

Percentage table:

Merge function in Power Query Editor:

Then expand Sales support and Percent column, add a custom column as below.

Result is as below.

In Dax:

You can build a calculated column in Percent table.

Sales for Sales Support =
CALCULATE (
    SUM ( Table1[Sales] ),
    FILTER ( Table1, Table1[Account Manager] = 'Percent'[Account Manager] )
) * 'Percent'[Percent]

Result:

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.