Here is my Measure:
Adjusted Water Level =
VAR WaterLevel = SUMX(Chickens,DIVIDE(Chickens[Water Level],2,0))
VAR Adjuster = CALCULATE(AVERAGE(Chickens[# of Eggs]),ALL(Chickens[Dates]))
WaterLevel + Adjuster
And here is what I get when I filter the visual:
My goal was to have a measure which adjusted the feed/water level by adding the average number of eggs to it in order to see if they rise and fall together.
Any idea why calculate() is effecting my visual?
Solved! Go to Solution.