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
1 year ago

Thank you for the sample data.  I's a bit inconclusive. Not clear to me how measure CC1 is calculated?  Is it based on Sum of Actual?

Daniel___'s avatar
Daniel___
Frequent Visitor
1 year ago

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