Forum Discussion

heidibb's avatar
heidibb
Icon for Helper IV rankHelper IV
2 years ago

Help using the CALCULATE with FILTER ALL

Hello, I am struggling with the performance of this calculation --  it is causing my visuals to spin and is using up a lot of resources.  Success LY UG = CALCULATE ( [% Final Grade Success]...
Need Help
heidibb's avatar
heidibb
Icon for Helper IV rankHelper IV
2 years ago

That didn't quite work, but I did get something to render using the calculation in the screen shot... however, it's giving me the "TY" rate in my "LY" calculation. It's not seeing the math I'm doing on the max(termaxis) - 6 for some reason.
For example, I want the .774 rate to show in the Success LY UG field for the 22EW4 column since that comes from the 21EW4 term (1 year prior). We use what's called Term Axis to find various prior terms.