IF statement

[APOUDEL1]

=if($(vShowCountPercent) = 'x', (count(distinct if(len(answer) > 0, id))))

I can't seem to understand the problem here. I get "Error in Expression" error on this one. I am trying to include this to enable conditioning for my measures. Thank you

[Vegar]

You have a variable in your expression, what's hidden behind it?

Maybe you should add a = sign in your dollar expansion like this :

=if('$(=vShowCountPercent)' = 'x', (count(distinct if(len(answer) > 0, id))))

[APOUDEL1]

Thanks for the quick response. That works like a charm.