Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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.
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
88 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |