Posts

Showing posts with the label dax

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

Image
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. 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] Is this a bug? Can anyone help? 1 Answer 1 Not enough information to qualify it as bug w...