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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Impactful Individual
Impactful Individual

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



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:



I'm using the latest version of PBI Desktop.


Is this a bug? Can anyone help?

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

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?

HI @webportal


Refer this page.


Prateek Raina

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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