Forum Discussion
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]...
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.