sumx difference betweeen Desktop and Service

[Larstc75]

Hi, I have a situation where a SUMX formula is behaving correctly in Desktop but provides very big numbers in the service. Never seen it before.. a bug?

This is the formula: 

Cost per Invoice Line = 
sumx(Fakturalinjer ; Fakturalinjer[Quantity]*Fakturalinjer[Unit_Cost_LCY])

see here: (No. 1019354 and the totals)

Desktop                                                                             

Service (No. 1019354 and the totals)

[v-chuncz-msft]

@Larstc75 

You may check if the following post helps.

https://community.powerbi.com/t5/Service/Thousand-Separator-and-Decimal-Separator/m-p/633330#M63484

[MFelix]

Hi @Larstc75 ,

Are tou sure that on both setups you have the same filters?

On the images you show the last rows are dfifferent so the calculations are not comparable, this can also the way the screenshots were taken but to what I can see the service image as more lines in the calculation than the desktop.

Regards,

MFelix

[Larstc75]

Yes I am sure. If you pay close attention, you will notice that there is a factor 100 difference on the Omk column for No. 1019354 and the Totals are just to the moon. This could not be done accidently by a filter. 

I think it is a bug. just don't know how to fix it.