Forum Discussion
% incorrectly updating when slicing - ALLEXCEPT DAX
Hi, I've created a measure to show me the percentage of responses to a particular question on a survey, over a number of years... Measure = SUM('FYE Data (2)'[Response]) / CALCULATE(sum('FYE...
You get a syntax error because the numbers of "(" and ")" in your formula are different. A theorem says that a necessary, albeit not sufficient, condition for a formula to be correct is the same number of the open and close parentheses.
AnonymousThank you - looks like there was a missing ) highlighted in red. Unfortunately that has the same impact as the other suggested solution.
Measure 4 =
var a = CALCULATE(SUM('FYE Data (2)'[Response]))
var b = CALCULATE(SUM('FYE Data (2)'[Response]), ALL('FYE Data (2)'))
RETURN
DIVIDE (a,b)