• Based on your description, I believe your problem is that you try to put everything into one fact table.

    The inspection is one fact table, with the grain being one row per inspection. Don’t do a QTY column, you’re violating the grain. You can add include an inspection count with the constant value of 1 to make it easier to get the QTY inspected from the fact table.

    Replaced parts is a separate fact table where the price should be part of fact, so you can add up the cost of all replaced parts.