'Power BI - Unpivot a few columns in a table without interfere the remains columns

So I have this table:

Original Table

I would like to transform the Defect columns into only one without affecting the total of the Inspected column. I've tried the Unpivot the selected columns and brought me this result

Unpivot selected columns

The total of inspected changed from 13 to 52. To solve that problem I've tried to duplicate the table and unpivot only the defects and remaining the inspected in the other table, however I need to make calculations between those tables and both are already related to a third table. Someone has any idea how can I solve this?

Thanks in advance

powerbi unpivot

Solution 1:^[1]

Add column by example after selecting Attributes, ie Attribute Index. Calculate count nulls, errors and percentages against the Attribute column total

Calculated Value = SUMX(VALUES(Attribute Index),CALCULATE(MAX(Value)))

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	STEPHEN OG

'Power BI - Unpivot a few columns in a table without interfere the remains columns

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]