Forum Discussion
DAx Support on cartesian table
Hi @lbendlin , Hi @v-lgarikapat ,
Thank you both for the time/patience and the support. I was able to figure out the way :).
So, Calculate + sumx + all is the key to be able to repeat over the rows te same amount in a cartesian table.
Thank you
Hi Daniel___ ,
Thanks for your prompt response
Your CC1 measure is a straightforward SUMX over the D_CC_Costs table's Actual YTD column, which works well whether applied directly or through the cartesian table of MD_* combinations. The challenge with CC2 arises when trying to subtotal by sender cost center using CALCULATE + SUMX + ALLEXCEPT, especially when the measure is applied via the cartesian table and the filter context doesn’t flow properly. To resolve this, you can use SUMX(VALUES(D_CC_Costs_Sender[CC_]), CALCULATE(SUM(D_CC_Costs[Actual YTD]))) to iterate over distinct sender cost centers, or apply KEEPFILTERS(VALUES(...)) to preserve granularity. If the MD_CC_Costs_Sender table is disconnected, TREATAS(VALUES(MD_CC_Costs_Sender[CC_]), D_CC_Costs_Sender[CC_]) can simulate the relationship and ensure the filter reaches the fact table. These approaches help maintain correct subtotaling and grouping logic across both direct and cartesian contexts.
We appreciate your engagement and thank you for being an active part of the community.
Best Regards,
Lakshmi.
Hi v-lgarikapat,
Did try the options which you mention ad they did not generate the outcome which I was looking for, repeat the same number over the rows as subtotal per Sender CC (in a cartesian table in my model all conbinations of the tables Start by "MD*").
would be possible to sugest other option?
Link of Excel file: "https://docs.google.com/spreadsheets/d/1fC8M8WFmWoRzIUx-1LQVbSrIEem-Ykro/edit?usp=drive_link&ouid=10...".
Thank you in advance.
Hi Daniel___ , Thank you for your responses. Could you please share a sample PBIX file that does not contain any sensitive or unrelated information? Having a reference would be extremely helpful.
We appreciate your engagement and thank you for being an active part of the community.
Best Regards,
Lakshmi.
Hi v-lgarikapat,
On the below link we can find the Link with the excel file, if we do the download and open it, then we can find t full model example (all data good to be shared and used).
Thank you in advance,
Hi Daniel___ ,
Thank you for sharing the sample data. While it provides some context, it’s a bit inconclusive on its own. It would be extremely helpful if you could share the PBIX file with all the relevant tables loaded and the appropriate relationships established
Best Regards,
Lakshmi.