Link Summary table to main data

[ChavdarG]

Dear all,

Hope someone can help me find a solution to this one.

All customers are in a table called ALL CCs (all cost centres).

Volume sales per item (SKU) are in a table called ALL Data PY-LE.

Individual SKU details are in a table called SKU Details.

I needed to do a manipulation that required me to summarize the volumes per cost centre and brand, thus creating a new table:

Summary by Brand by CC PY = SUMMARIZECOLUMNS('ALL CCs'[CCenter],'SKU Details'[Brand],"VOLUME PY",SUM('ALL Data PY-LE'[VOL BASE]))
 
In that new table I do additional calculations to arrive at a new column called "Full A&P PY".
The problem is that this column and table are not linked to the rest of the data and I obviously need to use the new column Full A&P PY.
Trying to connect it to ALL CCs, gives me a circular reference error:

 
I have a matrix by cost centre slicing by the info from ALL CCs.
The matrix now looks like this when I select any cost centre:

 
The measure I use is as follows but obviously not working:
FULL A&P PY 2 = CALCULATE(SUM('Summary by Brand by CC PY'[FULL A&P PY]),TREATAS(VALUES('Summary by Brand by CC PY'[CCenter]),'ALL CCs'[CCenter]))

Please let me know if what I am trying to achieve is possible and how?
I need the summarized table, otherwise I cannot achieve what I have to.

Thank you

[ChavdarG · Accepted solution]

Ok, managed to fix it by myself. FYI I did the following change to the summary table:

Summary by Brand by CC PY = SUMMARIZECOLUMNS('ALL Data PY-LE'[CCenter],'SKU Details'[Вид Търг.Марка име],"VOLUME PY",SUM('ALL Data PY-LE'[VOL BASE]))

Now summarizing by cost centre from ALL Data PY-LE and not ALL CCs. Now it allows me to make a relationship b/n Summary by Brand by CC PY cost centre and ALL CCs cost centre. 

And now it works.

Best regards,

Chavdar