I am struggling since 1 week on this issue and I would like to ask for your support.
I need to calculate the values of scrap over a process. In attachment you can find the PowerBI Model
I Have 100 product and for each product I have “Y” Process step to produce it (let´s take as example the “product 10” – with 5 process step - see screenshot)
The values (cost) of my product increase for each process step. For this reason I have to consider the cumulative cost for the scrap cost calculation
The Value of my product is given by the sum of “BOM cost” + “Labour” + “Process cost”
Set Up Scrap cost per one pc produced are = Set up scrap * Cumulative total cost without scrap / Batch size
When I calculate the “Cumulative total cost without scrap” the calculation is correct but when I used this measure to calculate the “Set up Scrap cost” I got wrong number
PowerBI use the column of “Total cost without scrap” instead of the “ Cumulative total cost without scrap” despite I have specified the right measure
See “check.xlsx” file column “T” (the correct calculation) and column F (the wrong PowerBI Calculation) / Column U (Check wrong calculation).
I can not understand where I am mistaking.
Your help will be really appreciated
Thanks in advanced