cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

sumx difference betweeen Desktop and Service

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                                                                             

 
 

sumx desktop.PNG

Service (No. 1019354 and the totals)

 

 

sumx service.PNG

 

 

3 REPLIES 3
Highlighted
Super User III
Super User III

Re: sumx difference betweeen Desktop and Service

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

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Frequent Visitor

Re: sumx difference betweeen Desktop and Service

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.

Highlighted
Community Support
Community Support

Re: sumx difference betweeen Desktop and Service

@Larstc75 

 

You may check if the following post helps.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors