topic Re: Nested Calculated Items in Calculation Group in DAX Commands and Tips

Nested Calculated Items in Calculation Group

mcolb88 — Thu, 20 Aug 2020 19:48:30 GMT

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

Re: Nested Calculated Items in Calculation Group

Anonymous — Thu, 20 Aug 2020 19:51:10 GMT

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)

Re: Nested Calculated Items in Calculation Group

mcolb88 — Thu, 20 Aug 2020 19:56:09 GMT

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

Re: Nested Calculated Items in Calculation Group

Anonymous — Fri, 21 Aug 2020 11:25:40 GMT

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

Re: Nested Calculated Items in Calculation Group

WCONGRAVE — Sat, 03 Jul 2021 13:35:23 GMT

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

Re: Nested Calculated Items in Calculation Group

Anonymous — Wed, 13 Oct 2021 08:05:35 GMT

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=asallproducts-allversions#sideways-recursion

Re: Nested Calculated Items in Calculation Group

m_holly10 — Fri, 18 Feb 2022 23:19:26 GMT

This was clutch! Thanks Anonymous