Forum Discussion
Nested Calculated Items in Calculation Group
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
6 Replies
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") )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)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
HI, Did you manage to acheive this? I'm trying to do the same....
This was clutch! Thanks Anonymous
