SKU count ver. SKU bellow minimum

Hi All

I need to count how many of my SKU's are bellow minimum.

Firstly I counted my SKU's = DISTINCTCOUNT('weekly stock'[Item Code])

Than I counted SKU's with 0 inventory = CALCULATE(DISTINCTCOUNT('weekly stock'[Item Code]); FILTER('weekly stock'; 'weekly stock'[Volume]=0))

Now I want to see how many SKU's are bellow minimum. And the minimum will be based on box quantity and item class. Depends on item class, check full box quantity and multiply by factor and set a minimum, and than check current stock, and count SKU where current stock is less then minimum. Factor will be different for different item class.

Example; If item class is B2, than minimum quantity is 80% of a full box quantity. Item "0020" is B2, and full box is 100 pieces, the minimum will be 80 pieces, current stock is 378 pieces, so is above minimum.

If item class ic C3, tahn minimum quantity is 20% of a full box quantity. Item "0009" is C3, and full box is 50 pieces, the minimum will be 10 pices, current stock is 5 pieces, so is bellow minimum

Factors for item classes are:

Weekly inventory table looks like that:

If anyone nows the solution please explain.

Thank you, Sebastian