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 Ibendlin,
The Measure CC1 is a simple Sumx from D_CC_Costs Table Column "Actual YTD". And this portion of formula is working well - either we apply the Measure via D_CC_Cost Table or via "cartesian table" (cartesian table being, add the all the combinations of the conection tables - Tables start by "MD*").
The Measure CC2 is where I´m strugling, so basically would be: Calculate + sumx + allexcept (same parameters as above with the filter being applying on D_CC_Cost_Sender CC_ and ideally in MD_CC_Costs_Sender CC_). The measure works well when we apply the measure via D_CC_Cost Table and are not able to identify the cost center and do the subtotal in the "cartesian table".
So here is where I would need your support advice,
Let me know if I was able to explain myself in a good way,
Thank you in advance
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,