Visual table cannot show correctly

I have below sales & staff cost data and have created below measure to sum up the total staff cost a) staff costs with brand "All" are splitted into Brand A, B, C by "Sales Ratio by Brand", b) staff costs with Brand A, B, C are sum up by brands directly.  When I use the measure in the visual table, the data cannot be shown correctly.  Don't know if the measure is incorrect or the relatioship mapped incorrectly.

Staff Cost = calculate(sum('Individual Staff Expenses'[Total Staff Expenses by Individual]), FILTER('Individual Staff Expenses','Individual Staff Expenses'[Brand]="All"))*CALCULATE(sum('Sales Data'[Sales Ratio by Brand]),ALLEXCEPT('Sales Data','Sales Data'[Dept],'Sales Data'[Brand])) + calculate(sum('Individual Staff Expenses'[Total Staff Expenses by Individual]),filter('Individual Staff Expenses','Individual Staff Expenses'[Brand]<>"All"),ALLEXCEPT('Sales Data','Sales Data'[Dept]))

Sales Data

Total Staff Expense by Dept

Individual Staff Expenses

Individual Cost Ratio by Salary = 'Individual Staff Expenses'[Salary by Cost Split]/calculate(sum('Individual Staff Expenses'[Salary by Cost Split]),ALLEXCEPT('Individual Staff Expenses','Individual Staff Expenses'[Dept]))

Total Staff Expenses by Individual = related('Staff Expenses by Dept'[Total Staff Expenses])*'Individual Staff Expenses'[Individual Cost Ratio by Salary]

Relationship

Table

My expected result is using the master lists of "Brand" & "Dept" to show below table:

However, when I use the master list of "Brand" & "Dept", the data only show the total value.

When I use the Column "Brand" under Sales Data, it can only show the splitted cost of brand "All" correctly but not the total cost with different brands.

When I use the Column "Brand" under Individual Staff Expenses, it can only show the total cost with different brands correctly but not the splitted cost of brand "All".