BOM ( Manufacturing Bill of Material ) totals is incorrect for final assembly cost

[BrianJ]

@Unni ,

I started to work through a specific solution on this, but realized that I think you need to go back through some of the basic coursework first. Here are some of the problems I’ve identified:

1. Your data model is not correct - you are using the Invoked Function table, but it is not connected to the model by any relationship.
2. You are using implicit, rather than explicit measures, which in general is not a good practice and will not work for measure branching, as is needed here
3. General model cleanup - unnamed table and columns make it very difficult to figure out what’s going on in the model
4. Need to apply fix totals pattern

Here are specific videos I would recommend:

https://forum.enterprisedna.co/t/quick-measure-feature-positives-vs-negatives/4885

https://forum.enterprisedna.co/t/why-your-total-is-incorrect-in-power-bi-the-key-dax-concept-to-understand/5108

https://forum.enterprisedna.co/t/measure-branching/5962

Data Transformations & Modeling

Fix Incorrect Totals

When using a measure column in a visual, it is not uncommon in Power BI to find that the totals are incorrect. The Fix Incorrect Totals DAX pattern can be used to correct this issue. When a DAX measure is providing the correct detail value it often, unfortunately, provides an incorrect value for the total row. This is due to there being no evaluation context for the total row. For example, when comparing the [Total Sales] to the [Sales LY] to find the minimum for a customer using the simple DAX…

I hope this is helpful.

• Brian