Displaying producible amount based on bill of materials

[Bondeuz]

Hi,

I need some help with figuring out how the relationship between two of my tables should work in order to display correct information.

I want to display if we are able to produce an item based on its bill of materials and the current inventory of items. Currently i cannot figure out how to get the correct answer from the column "Producible" when listing the items by No from the BON_Artiklar table.

My formulas

Max Units by Item = RELATED(BON_Artiklar[InventoryField])/Prod_struktur_ExcelProdBOMLine[Quantity_per]

Max Producible Units = 
CALCULATE(
MIN(Prod_struktur_ExcelProdBOMLine[Max Units by Item]),
ALLEXCEPT(Prod_struktur_ExcelProdBOMLine,Prod_struktur_ExcelProdBOMLine[Production_BOM_No])
)

Producible = IF([Max Producible Units]>0,"True","False")

I have uploaded a .pbix file for easier inspection.

https://drive.google.com/file/d/1ZGepAQlZRHXOOm-TdIpnLjOykKr9zLq9/view?usp=sharing

Thank you.

[Anonymous]

Hi @Bondeuz ,

Depending on the information you provide, you can follow these steps:

1.Change your measures into columns.

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}