Forum Discussion
Solved
If statement not working properly.
I have a measure that is calculating a moving average of deliveries which seems to work fine. I then made a new column with an if statement to compare the daily delivery count against th...
you created a calculated column right? The row context is not propagated to the filter context, meaning you might compare it with the running average of not only houston...
What you can do: create a new calculated column with the measure in it, so you can see what your above / below formula is comparing against.
you created a calculated column right? The row context is not propagated to the filter context, meaning you might compare it with the running average of not only houston...
What you can do: create a new calculated column with the measure in it, so you can see what your above / below formula is comparing against.