Dynamic formula based on corresponding column

Hi everyone,

I have the following formula:

United Measure =

VAR SelectedColumn = SELECTEDVALUE('C'[C])

Return SWITCH(SelectedColumn;

"C1"; SUMX('E&A';'E&A'[Hours]*RELATED('A&C'[C1]));

"C2"; SUMX('E&A';'E&A'[Hours]*RELATED('A&C'[C2]));

"C3"; SUMX('E&A';'E&A'[Hours]*RELATED('A&C'[C3]))

• My goal is to fill the matrix at the bottom without repeating the line ("C1"; SUMX('E&A';'E&A'[Hours]*RELATED('A&C'[C1]));) for each single C's (about 100 columns).

As a quick run down, those are the table I am using:

Table 1: (List of A's)

Table 2. (List of E's)

Table 3. (List of C's)

Table 4. (Relation between A's and each C's)

Table 5. (Relation between A's and E's in hours)

End matrix:

I hope this is understandable.

Best regards,