Query Return Different Result in Desktop than when Published to Workspace

[Anonymous]

I have a query to calculate sales score with the sales%(image 1), it is calculating correctly in desktop (image 2), but when I published the report to the workspace and check right away, the sales score does not follow the query logic(image 3). For example,  13.12%*30*5 =19.67, which is correct on the desktop(image 2) calculation, but returned 40.72 when published to the workspace. I download the report to check what's wrong after it gets published, the calculation is fine again. Can anyone let me know what is causing the issue? 

[v-yulgu-msft]

Hi @Anonymous,

I was not able to reproduce this problem on my side. 

Please remove the report on Power BI service, and re-upload it directly from Service via clicking on "Get data" to see if problem persists. If possible, please share the sample .pbix file for check. Please mask the senssitive data before sharing.

Regards,

Yuliana Gu

[Anonymous]

Thank you for the response! But getting data directly from the service didn't solve the issue. So I want to rank the strategic group by category and marketplace. In the desktop version, when either of those filters is selected, the rank appears to be fine and the calculation for sales score is correct, but when published to the service, the calculation and rank get messed yo with these filter selected. When I published the table without the rank column, the sales score is calculating correctly regardless of filter selected. So I think must be something to do with the rank formula. 

( In Service with filters selected)

 (In Service with no filter selected)

 Rank Query

(Desktop no filter selected)(Desktop with filter selected)

[Anonymous]

Thank you for the response! But getting data directly from the service didn't solve the issue. So I want to rank the strategic group by category and marketplace. In the desktop version, when either of those filters is selected, the rank appears to be fine and the calculation for sales score is correct, but when published to the service, the calculation and rank get messed yo with these filter selected. When I published the table without the rank column, the sales score is calculating correctly regardless of filter selected. So I think must be something to do with the rank formula. 

( In Service with filters selected)

 (In Service with no filter selected)

 Rank Query

(Desktop no filter selected)(Desktop with filter selected)