Forum Discussion
han_rj
Helper IV
Helper IVNested Calculation item not working
I have created a calculation item for This Year and Prior Year and wanted to calculate Variance for it. But the varaince calculation item is not working Variance = CALCULATE(SELECTEDMEASURE()...
johnt75
Super User
Super UserA calculation group is only called once per measure, so you cannot nest them like this. You would either need to have the variance in a separate calculation group or replicate the time intelligence logic in the TY & LY calculation items.
han_rjHelper IV
Helper IVThank You for responding, I tried both ways did'nt work