Forum Discussion
webportal
Impactful Individual
Impactful IndividualPossible Bug? Measure returns different results on PBI Desktop and Service?
Hello,
This measure:
ValorLíquidoProduto =
SUMX (
FILTER ( 'order_product'; 'order_product'[EstadoEncomenda] = "confirmed" );
(
(
order_product[order_product_price]
* ( 1 - RELATED ( nomes_produtos[comissao_perc] ) )
- RELATED ( nomes_produtos[comissao_fixo] )
)
/ order_product[Câmbio AOA]
- order_product[DescontoProporcional]
)
* 'order_product'[order_product_quantity]
)Returns €75 for order id 1940 as you can see below in Power BI Desktop (which is correct):
And it returns €149 for the same order in Power BI Service:
Why? It is the same model!
Is this a bug? Can anyone help?
Here is the relationship between the 2 tables in the data model:
- Nope, I've found out what the problem is: field [comissao_perc] was not converted into decimal number. So, in PBI Desktop, somehow the calculation is good, but in PBI Service it isn't (it seems this value is just ignored). So, there is a difference in treatment of values between Service and Desktop
4 Replies
gipilusoResolver II
it is very strange, are you sure that PBI Desktop and Service are working on the same data?
Try to click Refresh button to update the date on the desktop.
webportalYes, they are exactly the same model, I've re-published and changed some visuals layout to test.- gipiluso
I think it could be a misalignment between data (not model9.
If you are in import I suggest click on refresh on your pbi desktop.
In case of direct query verify that you are using the same dataset