Forum Discussion

mcolb88's avatar
mcolb88
Helper III
6 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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