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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
11 months ago

Since MD_PC has no relation to the fact table you need to use a measure to enforce the cartesian.

 

See attached.

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