Forum Discussion
Unexplainable behaviour between Desktop and Service - values change
Idrissshatila it's possible that I found it... It seems that Desktop and Service treats blank differently, e.g.,
in Dekstop:
(blank()<>"xyz")=false
but in Service
(blank()<>"xyz")=true
I had a measure that relied on that implicit ((blank()<>"xyz")=false) behaviour and it seems that it was the one that was messing things up.
Idrissshatila it should be something like that right? But I'm not sure it is because this is exactly step by step what I'm doing:
- refresh semantic model in service (actually the refreshing at this stage doesn't matter I don't think as the result is the same regardless)
- open the report in service -> my visual says=138 (the wrong number)
- I download the file from Service and open it in Desktop doing absolutely nothing else and the exact same visual says =5 (the correct number)
Actually the same behaviour affects multiple measures - the only constant that I noticed is that data in Desktop are correct, in Service incorrect.
I even tried re-publishing it as a new report/semantic model hoping that it makes a difference but did not - still the same issue...
How's that possible?
Idrissshatila it's possible that I found it... It seems that Desktop and Service treats blank differently, e.g.,
in Dekstop:
(blank()<>"xyz")=false
but in Service
(blank()<>"xyz")=true
I had a measure that relied on that implicit ((blank()<>"xyz")=false) behaviour and it seems that it was the one that was messing things up.