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

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.