Missing Constant bug when using a filter

#1

Hello. I’m encountering a strange bug. I contacted Customer Service and am awaiting their feedback, but I’m posting here to see if anyone can shed some light.

Basically, I’m measuring income, called “Rent from local farmers”, and I want to compare it against the goal for this year. I manually added that goal so it remains as a constant.

When I don’t have the account number filter selected, my goal is showing up.
22%20AM

But when I apply the filter needed, since we haven’t received that rent this year yet, thus it’s at zero, for some reason the goal disappears and becomes zero too.
29%20AM

Does anyone know why this is happening and how can I fix this? I’m using Version: 7.0.1.1002

#2

The contextual measure you added as a constant is strictly dependent on the filters present at definition time.
If the goal is 100 for “All Products” (for example), filtering on “Fruits” would NOT display the 100 value. It would display the goal for “Fruits” if defined, otherwise the value would remain empty.
In your case, you have to define the yearly goals for all the possible filter values, or disallow such filtering operations.

#3

If it’s as @adrian.dobrin says, this got me too this week. A contextual measure needs to be defined for each filter setting. So change the filter, add it, repeat.
On the other hand, you can create a formula measure with the number that you want, and that will stay despite filtering.

#4

Hello, it is a formula measure. That’s why I don’t understand how it disappears.

#5

Hello. I don’t think I understand. I went to formula, and wrote it to be that amount. It’s never defined as being a goal for all products.

#6

If you added the constant as a formula, and the value is not displayed when the filter is on, then you should contact support and provide the duplication steps.

#7

Where does the goal amount come from?
Is it a formula, if so share please.
Also if it is, does it rely on any values that you filtered out?