• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by Micro Bot


28 Nov, 2024

Updated at 02 Dec, 2024

Nested Calculation item not working

I have created a calculation item for This Year and Prior Year and wanted to calculate varaince for it.

But the varaince calculation item is not working 

Variance = CALCULATE(SELECTEDMEASURE(),Time_Period[Time_Period_Grp] = "TY") -  CALCULATE(SELECTEDMEASURE(),Time_Period[Time_Period_Grp] = "LY")

 

han_rj_0-1732802071718.png