Forum Discussion

Daniel___'s avatar
Daniel___
Frequent Visitor
1 year ago
Solved

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 alloca...
  • Daniel___'s avatar
    Daniel___
    11 months ago

    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

Daniel___'s avatar
Daniel___
Frequent Visitor
11 months ago

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.

v-lgarikapat's avatar
v-lgarikapat
Community Support
11 months ago

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.

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    11 months ago

    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.