Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
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.
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
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |