Dax measure

[Anonymous]

So I've used this dax measure to find the weighted average for the profit margin which was fine however, after a while it changed and added 0.3 on but the data in excel is all the same. I cant seem to figure out why this has happened. If anyone knows please let me know thanks.

Weighted Average Profit Margin =

DIVIDE ( [IEA*PROFIT MARGIN], SUM ( 'Detail'[IEA] ) )

[V-pazhen-msft]

@Anonymous 

Please share a sample table, it is hard to say without see the table. And also share the dax for the iea profit margin..

Thank you

Paul

[Fowmy]

@Anonymous 

The information provided is not sufficient to understand the exact problem. If you can share some sample/dummy data and the expected result, then a solution can be suggested.

[Anonymous]

So my data changed from 0.47 to 0.50 which is inaccurate. But there was no changes made to the data set