Forum Discussion
Is this a bug?
The reason Measure 3 is giving -1, is becuase Measure 4 is blank. You need to find out why Measure 4 is blank.
Most likely, the max function you are using in Measure 4 is returning blank. I don't know why this is happening without looking at your dataset.
One thing you can do is to use the isblank function in measure 3 to check if measure 4 is blank. If it is, then return a blank. This way you can avoid getting -1
Measure 3 = if(isblank([Measure 4]), blank(), year([Measure 4]))
Hope this helps
Nishant
Both Measure 3 and Measure 4 don't point towards each other. The printscreen where Measure 3 is included has the exact same dataset, measure, visuals as the one that does not have Measure 3. The only thing I do, is drag in 'Measure 3' into the visual.
This simply should not happen.