Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Ok, managed to fix it by myself. FYI I did the following change to the summary table:
Ok, managed to fix it by myself. FYI I did the following change to the summary table: