Variable has same formula but gives different number

[shirleyc40]

Hi. 

I have a variable that is equal to count (<some condition> ID), but when I put it in bar chart, with the dimension being month and the measure being the variable, I get a the same number for each month. Are we allowed to use variables to store calculations that aren't constant?

[Nicole-Smith · Accepted solution]

In your variable definition, if you start it with an = it is calculated outside of your chart.  Remove the = from the front of the variable definition, and it will calculate it according to whatever chart you use it on.

[mdmukramali]

Hi,

While created the Variable if you put = before the expression i will calculate the value and it will store one value in that variable.

remove the = before the expression and use =$(your variable) then i will calculate as per your Dimension.

Thanks,

Mohammed Mukram