Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
58 |