Visual table cannot show correctly

Hi trinachung ,

Keeping the originial relationship model you have you need to create the following measures:

Individual Cost Ratio by Salary =
SUM ( '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 AUX =
IF (
    SELECTEDVALUE ( 'Individual Staff Expenses'[Brand] ) = "All";
    SUM ( 'Total Staff Expenses'[Total Staff Expenses] )
        * CALCULATE (
            [% sales];
            FILTER (
                ALL ( 'Sales Data'[Brand] );
                'Sales Data'[Brand] = SELECTEDVALUE ( Brand[Brand] )
            )
        );
    CALCULATE (
        SUM ( 'Total Staff Expenses'[Total Staff Expenses] ) * [Individual Cost Ratio by Salary];
        FILTER (
            'Individual Staff Expenses';
            'Individual Staff Expenses'[Brand] = SELECTEDVALUE ( Brand[Brand] )
        )
    )
) + 0


% sales = SUM('Sales Data'[Sales])/CALCULATE(SUM('Sales Data'[Sales]);ALL('Sales Data'))

Total Staff Expenses by Individual =
IF (
    HASONEVALUE ( Dept[Dept] );
    SUMX ( Brand; [Total Staff Expenses by Individual AUX] );
    IF (
        HASONEVALUE ( Brand[Brand] );
        SUMX ( Dept; [Total Staff Expenses by Individual AUX] );
        SUM ( 'Total Staff Expenses'[Total Staff Expenses] )
    )
)

Now just setup you table as needed.

Your issue was related with the ALL part of the split by brand of the department costs, so you need to force for those the split by % of sales.

As you can see in the file I have attach I have no additional calculated columns all measures.

Check the result in attach PBIX file.