Nested Calculated Items in Calculation Group

[mcolb88]

All, 

Fairly new to calculation groups and want to know if the following is possible. 

My calculation group has 2 calculated items A and B.  I want to get a percentage, and add a third item C = DIVIDE (A, B). My question is if there is a way to reference the calculation items in the expression for C or do I need to repeat the expression in C, as in DIVIDE ( A expr, B expr). 

Reason I ask is for maintainability, if I change A for example, I would need to change the A expression in C, otherwise I would be off. Also, the expression for my B item is quite lengthy and want to keep it easier to read.

Thanks

[m_holly10]

This was clutch! Thanks @gronnerup 

[gronnerup]

Be carefull of using sideways recursion as it can cause a number of problems. Instead write the full expression again.

But answering you question this can be achived though

DIVIDE(
   CALCULATE(SELECTEDMEASURE(), 'CalcGroup'[CalcColumn] = "Calc item A"), 
   CALCULATE(SELECTEDMEASURE(), 'CalcGroup'[CalcColumn] = "Calc item B")
)

https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...

[WCONGRAVE]

HI, Did you manage to acheive this? I'm trying to do the same....

[harshnathani]

Hi @mcolb88 ,

Use Variables.

https://www.sqlbi.com/articles/variables-in-dax/

https://docs.microsoft.com/en-us/power-bi/guidance/dax-variables

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[mcolb88]

I undestand the use of variables, I don't want to repeat the expression in the calculation of item C, I simply want to reference another calculated item. Is that possible?

Thanks

[Anonymous]

You can use one calc item in another in the same group. Just be careful not to introduce infinite loops.