The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Could you please help me to correct the measure to show the number of components in each layer of BOM as described in the picture?
I have created the two measures below but they do not works. I also attached the link to download pbi desktop file for your inspection.
The link to download the .pbix file
https://bit.ly/3HhW8WE
Solved! Go to Solution.
Hi Ibendlin,
Thank you very much for your time. I have corrected the issue by myself with the same logic as the code block above.
You have a couple of problems. One of them is that you don't really have a hierarchy.
As you can see a substantial number of items have multiple parents. That's a no-no in a hierarchy.
You are better off with a snowflake style data model where you describe for each actual product what their BOM is, and then for these components what their sub-BOM is etc.
Hi Ibendlin,
Thank you very much for your time. I have corrected the issue by myself with the same logic as the code block above.