Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Bondeuz
Frequent Visitor

Displaying producible amount based on bill of materials

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.

 

Bondeuz_0-1703152947825.png

Bondeuz_1-1703153077726.png

 

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.

 

1 REPLY 1
Anonymous
Not applicable

Hi @Bondeuz ,

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

1.Change your measures into columns.

vyifanwmsft_0-1703230727129.png

 

Final output:

vyifanwmsft_1-1703230727130.png

 

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.