Forum Discussion
Is this a bug?
Fair enough. Here is the same scenario with the same data.
And yes, all columns contain the same measures/ data as before Measure 3 was added.
But you say this is how DAX works. How can a 2nd measure in the same matrix influence results of another measure? I've never seen this happen before. Not even with more complicated filter usages. Even the non measure columns are affected by 'Measure 3'.
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.