Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
webportal
Impactful Individual
Impactful Individual

Different value of calculated column in Power BI Desktop and Power BI Service

Hello,

 

I have a calculated column that calculates a price in Power BI Desktop. It works correctly.

However, after publishing the same report and dataset to Power BI Service I get different values!

See an example below:

Desktop.PNGService.PNG

 

I'm using the latest version of PBI Desktop.

 

Is this a bug? Can anyone help?

7 REPLIES 7
prateekraina
Memorable Member
Memorable Member

Hi @webportal,

 

What is the data source of your file?

I suspect it is happening becauase your power bi dekstop file is not refreshed and when you hit publish, it refreshes the report automatically on service. Thats why there is a mismatch.

 

If above is not the sceanrio in your case, please share the measure formula you have used to create this.

 

Prateek Raina

Hi @prateekraina, thanks for your support.

 

The data source is a MySQL database. It can't be a matter of differences in refreshing because the dataset is the same in Desktop and Service. The difference is in a calculated column. It returns different values!

 

Here's the DAX expression for the column:

 

Preço correto = 
('order_product'[order_product_price]*(1-RELATED(nomes_produtos[comissao_perc]))-RELATED(nomes_produtos[comissao_fixo])) / 'order_product'[Câmbio]
    - order_product[DescontoProporcional]

Well, this is weird. Becuase calculated column doesn't behave like this untill and unless you have dependency on a Datetime value computed through calcuated column.

 

I would still insist you to refresh your Power BI desktop file.

Also, Is there any chance that you could share the pbix so that i can repro the issue at my machine?

 

Prateek Raina

Yes, this is indeed weird, and I suspect it is a bug.
The calculated column returns the correct value in Desktop and the wrong in Service.
Both have been refreshed and looking at the tables I can see the data imported from MySQL is the same.
Unfortunately, I can't share the Pbix file with you as it contains sensitive data.

Well, in that case i would suggest you to raise a support ticket with the team if you have Pro License.
If not, then you can raise an issue but they would ask the repro steps which unortunately you won't be able to provide.

 

Meanwhile, try to rewrite the calculated column in a simpler way. Avoid using RELATED and then see the results.

 

Prateek Raina

Hello,
I do have a Pro license, but can't find out where the support ticket button is located, must be hidden somewhere...
Do you know?
Thanks

HI @webportal

 

Refer this page.

 

Prateek Raina

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.