Calculation Group Help

[amalrio]

Hi All, 

seems a long shot, not sure is it possible, just wondering is there anyway you can get the diffrence of two calcluation items in the same calculation group as a third calculation item. please refer the the image below 

I have two calculation items , 1) Crusher Feed 2) Expit. I want my third calculation iteam to be 3) Expit MM = Crusher Feed - Expit

maybe it is against the law og gravity 🙂

[DataInsights · Accepted solution]

@amalrio,

This is sideways recursion (a calculation item that references another calculation item in the same calculation group). It increases the complexity of the expression, however. I avoid sideways recursion which means duplicating DAX, but it avoids additional complexity.

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