Measure not working in Service, working on Desktop - No errors

[mpros]

Dears,
how it's possibile that in desktop version the measure works fine, while in service (web app) does not?

Stdev(x) stoc = CALCULATE([Stdev], filter(ALLSELECTED(Accoda1[WeekNumSource]),Accoda1[WeekNumSource]<=max(Accoda1[WeekNumSource])),ALLSELECTED(Accoda1))

[Anonymous]

Hi @mpros ,

Could you please check in Service what is the data type of the WeekNumSource column?

In Power BI, in case of columns of numeric type, all the numbers in the matrix are rendered right-aligned. But in this screenshot of yours, here it is presented in a left-aligned manner, indicating that the column seems to be of text type.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mpros]

Dear  v-junyant-msft,

If I explore the entire dataset it interprets it as "Integer (?)", proposed summary is sum as you can see in the dataset, (although left-aligned) calculation executed.

If I explore the single object  (inspecting the object, data explore) the result is that in interprest it as (Text?) as you suggested,  (even though proposed summary is still a sum) no calculation executed. 

Anyways I don't explain why it shouldnt:
-Calculate a value if it interprets it as text

- How to solve the problem?

Thanks and regards,
Marco

[Anonymous · Accepted solution]

Hi @mpros ,

I really can't reproduce your problem.
Can you try to delete and republish to Service, or publish to another workspace and then open it to see if the same problem exists?

Best Regards,
Dino Tao

[mpros]

Hi  v-junyant-msft,
republished with another name in same workspace and now for some reason it works 😀

Thanks and Best Regards,
Marco

[AnalyticPulse]

hi @mpros 

which connection type you are using in development environment and on service?
if you're using import in desktop app and then you upload it to service, there is chance that data is different for this chart in your service and oon your desktop app,
i suggest you check your data in service.

Powerbi Blog:
https://analyticpulse.blogspot.com/

Youtube:
https://www.youtube.com/@AnalyticPulse

[mpros]

Hi @AnalyticPulse

The semantic model is in import mode; if I explore the data inside PBI Service I get the measure to work correctly:

Desktop version:

It appears to me more like a bug/glitch.

Regards