Unexplainable behaviour between Desktop and Service - values change

[austris]

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]

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

[austris]

Thanks @Idrissshatila  - tried that - makse no difference...

[Idrissshatila]

@austris this is weird, there must be a filter that is affecting your data.

[austris]

@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?

[austris · Accepted solution]

@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.