Forum Discussion

Junaid11's avatar
Junaid11
Helper V
3 years ago
Solved

Count Product Created from Remaining Inventory

Hello, I have a table which is below: Product Raw Material Units Required to Create Product Available Inventory ABC A 1 456 ABC B 2 22 ABC C 1 334 DEF D 1 677 D...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    3 years ago

    Hi Junaid11 ,
    If I understand your request your outcome will be this:

    If you would please use this measure:

    Number of Products Constrained = 

var _Product = MAX(Constraints[Product])

var _calc = CALCULATE(MIN(Constraints[Count per Raw Material]), FILTER(All(Constraints),Constraints[Product]=_Product))

Return _calc

    After you create  a column in Power Query that adds a column which shows the maximum number of units that can be built after being constrained by the raw material input.  Classic economics!


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel



Nathaniel_C's avatar
Nathaniel_C
Community Champion
3 years ago

Hi Junaid11 ,
If I understand your request your outcome will be this:

If you would please use this measure:

Number of Products Constrained = 

var _Product = MAX(Constraints[Product])

var _calc = CALCULATE(MIN(Constraints[Count per Raw Material]), FILTER(All(Constraints),Constraints[Product]=_Product))

Return _calc

After you create  a column in Power Query that adds a column which shows the maximum number of units that can be built after being constrained by the raw material input.  Classic economics!


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel