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 ,

 

Link for PBI file: "https://drive.google.com/file/d/1deO9MnhJA_6DoITfBfzNBawEklG50oUl/view?usp=sharing".

 

So the goal here is create a Cartesian table with all the combinations of tables names started by MD*, Then will need to have the same value on a row level when the follow combination match MD_CC and MD_Dates (the sumx would be from the table D_CC_Actuals).

Example as below:

MD_CC_AC                | MD_Dates   | MD_CC            |MD_PC                | Amount (Intention)

Bought in D&D         | 001.2025      | 1060070300   | 5311010119       | 811145

Communications       | 001.2025      | 1060070300   | 5311010119       | 811145

Bought in D&D         | 002.2025      | 1060070300   | 5311010119        | 730031

Communications       | 002.2025      | 1060070300   | 5311010119        | 730031

Bought in D&D         | 001.2025      | 1060070300   | 5311110125       | 811145

Communications       | 001.2025      | 1060070300   | 5311110125       | 811145

Bought in D&D         | 002.2025      | 1060070300   | 5311110125        | 730031

Communications       | 002.2025      | 1060070300   | 5311110125        | 730031

 

 

Let me know in case you have some question.

 

Thank you

  • Daniel___'s avatar
    Daniel___
    Frequent Visitor
    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
      10 months ago

      Hi Daniel___ , 

       

      Thanks for the confirmation and for sharing the resolution, it’s really appreciated.
      We value your engagement and thank you for being an active part of the community.

       

       

      Best Regards,

      Lakshmi.