Matrix table with multiple columns as rows and measures doing calculations

Hi Ashish,

Thank you for your response. What you are referring to is I believe a bridge table. However I don't believe that will help resolve the problem I have.

If table A is the unpivoted table, with duplicates of the customer ID and the constructs, table B is the cost table, and table C is the bridging table with a unique list of customer IDs, the one to many relationships will be on the customer IDs. If I use the unpovited table to list out the constructs, I don't see how the cost table would then know to associate each cost with construct, unless I were to use a cross filter direction relationship that goes both ways between the unpivot table and the bridge table.

That would then bring the concern of using a two directional filter relationship, which I am not very familiar with but have read should typically be avoided due to potential undesired results.

Below are examples of the tables. Table A has customer information that associates only to the customer, and not directly related to the cost table (noting this in case it is suggested to move the construct column to the cost table).

Table A:

Table B:

Table C: