Variable is static in straight table?

[#1]

I created a variable to use in a straight table expression. For some reason when I use it, the value doesn't change for each dimension value, but when I take the same thing that I set the variable to and put that in the expression in the table, the values do change based on the dimension. This is what the variable is set to:

=if(GetSelectedCount([Production Date]) <> 1, '-',

if(count([App Flag]) < 1, '-',

num((count(distinct if([App Flag] = 'Yes', [ID Number]))/count(distinct [ID Number])),'#,##0.00%')))

Is there anything I can do to make the variable act as a chart expression?

Thank you

[sunny_talwar · Accepted solution]

When you define the variable in variable overview, remove the equal sign in front of the expression

The Little Equals Sign