Forum Discussion

austris's avatar
austris
Regular Visitor
1 year ago
Solved

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