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?