Correct measure to count number of components in BOM structure

[lionx]

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. 

Total items =

VAR Val = DISTINCTCOUNTNOBLANK(flattenHierrachy[no])

VAR EntityShowRow =

    [BrowseDepth] <= [BrowseDepth]

VAR Result =

    IF ( EntityShowRow, Val )

RETURN

    Result

Count components of earlier level =

IF (

    [BrowseDepth] > [MaxNodeDepth],

    BLANK (),

        IF([BOM] = "L0", DISTINCTCOUNTNOBLANK( 'flattenHierrachy'[Level 1] ),

            IF([BOM] = "L1", DISTINCTCOUNTNOBLANK( 'flattenHierrachy'[Level 2] ),

                IF([BOM] = "L2", DISTINCTCOUNTNOBLANK( 'flattenHierrachy'[Level 3] ),

                    IF([BOM] = "L3", DISTINCTCOUNTNOBLANK( 'flattenHierrachy'[Level 4] ),

                        IF([BOM] = "L4", DISTINCTCOUNTNOBLANK( 'flattenHierrachy'[Level 5] ),

                            IF([BOM] = "L5", DISTINCTCOUNTNOBLANK( 'flattenHierrachy'[Level 6] ),

                                DISTINCTCOUNTNOBLANK( 'flattenHierrachy'[Assembly Item] )

)))))))

The link to download the .pbix file  
https://bit.ly/3HhW8WE

[lbendlin]

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.

[lionx · Accepted 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.