Sankey Chart with multi-parent in parent-child hierarchy

[Anonymous]

Hello,

I have the following issue. Im trying the visualize the BOM of some products. I am using a Child-parent structure, but I have some duplicates (since some semi-finished products are used in many other finished products).

The data have the following shape : 

Child	Parent
GMT 0333	NULL
GMT 0391	NULL
FS 099	GMT 0333
FS 099	GMT 0391
PC 213	FS 099
CT 013	FS 099
CT 041	FS 099

GMT 0333 and GMT 0391 have no parent, that means that they are the finished product (the root of the tree).

FS 099 is a finished product, used in both GMT 0391 and GMT 0333.
Many raw materials make up FS 099.

The problem that I have is that the Sankey chart seems to only consider the first instance of FS 099 in the visual. As we can see below, when I filter on GMT 0333, the FS 099 works fine and the tree is visible.
But for the GMT 0391, the FS 099 appears like a raw materials, and we can't see the rest of the tree.

I feel like Power Bi only consider one instance for duplicate in a child-parent hierarchy.
How can I deal with this ??

Thanks for your help !

normally the tree should continue after the FS 099 here

[Anonymous · Accepted solution]

Hi @Anonymous ,

Maybe you can create below calculated column and add it to destination in Sankey chart:

UniqueID = 'Table'[Child] & "_" & 'Table'[Parent]

Count of Unique Relationships = 
CALCULATE (
    DISTINCTCOUNT('Table'[UniqueID]),
    ALLSELECTED('Table')
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.