Forum Discussion
Unexplainable behaviour between Desktop and Service - values change
Hi all,
Any idea what might cause the same measure to have a different value when viewed in Desktop vs in Service?
This is what happens - I build my report in desktop, refresh it (import) and publish it - several exact same measures display different numbers in exact same visuals (table) - and the difference is massive (e.g., it would be 4mil in Desktop and 140mil in Service) - the service number is wrong, by the way. It's the same user (me) with the same rights with same datasources - everything is the same but the numbers just are different...
The otherway it the same - I can download the .pbix from Servcice, open it in Desktop and desktop again would show the correct number while the Service had the massively increased number...
What on Earth could be causing that?
I tried all - clearing cache in browser, different browsers, incognito mode - no impact - Service wrong, Desktop correct...
Desktop is 2024-Aug version.
The measures that behave like that do calculate {another measure} and apply some filters.
Any clues?
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.
5 Replies
- IdrissshatilaSuper User
Hello austris ,
there must be applied filters on service, try reseting filters using the green icon in the screenshot.
subscribe to My youtube channel https://www.youtube.com/@PowerBISolution
- austrisRegular Visitor
Thanks Idrissshatila - tried that - makse no difference...
- IdrissshatilaSuper User
austris this is weird, there must be a filter that is affecting your data.