DAx Support on cartesian table

Hello all,

Would like to get you support for a Dax formula. Teorical concept: there are two tables with data one Cost centers (D_CC_Costs) with Expenses and other table the final oucome of allocation to profit centers D_Allocation (done by a automated tool), and what I would like to create is a table with allocation and gave the details from the cost center (such, which kind of expenses: as travel, external support costs and so)
Can not attach the Excel/powerbi document but have the data as below (already with the conection created and D_* data tables and MD_* lookup table).

What I was trying was using virtual table to do this calculation, with all variables combination (as a cartesian table).
From the D_Allocation table I just want to add the Account from D_CC_Costs table so then the calculations can be done (in my real scenario this cartesian/Merge table could go easily to hundred thousand million of rows)
Then, my think was with Calculate( Sumx(generate(Table,generate(Table,...)),..) Allexcept), I would be able to know how much the total of the Sender CC (regardless of the type of expenses from table D_CC_Costs) I´m receiving, so then from these would be just multiply the received CC Sender amount (from D_Allocation table ) / Total CC from D_CC_Costs (get the % of allocation) multiplying by the overall amount from the expenses (and all would work out).
My issue in above scenario is allexcept on this new cartesian table do not work as I expect (have the same amount over the rows per sender CC - as I was expecting to behave), but present the overall costs no matter the CC (or other number).
Can you help me with a way to make it work (with the way I was doing or a different way)?

D_Allocation table:

D_CC_Costs Table:

Let me know if I was not clear to express myself,

Thank you in advance