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]...
Your suggestion is giving me all null values.
I have narrowed down the fact that it doesn't like the math on max(termaxis) - 6 directly in the calculation. Couple checks I've done:
- When I do a check calculation simply CALCULATE(max(sp_TermData[TermAxis]) - 6), and look at the result, I get what I want.
- When I do a check calculation of UG LY TermAxis = CALCULATE(max(sp_TermData[TermAxis]) - 6,sp_TermData[TermAcademicLevelCode] = "UG"), I get what I want.
- When I use that UG LY Termaxis in my calculation like this:
Success LY UG =
CALCULATE (
[% Final Grade Success],
sp_TermData[TermAxis] = [UG LY TermAxis]
)
I get an error that says "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression."
I have used the performance analyzer a bit, but not sure how to use it to figure out the issue on this calculation.