Pleaseee Help :( You Can't create a direct active relationship

[Melissa27]

SAMPLE DATA

Hello everyone,

In my p-nozel table, my product codes are written in the column P_düse0 and these codes do not repeat. special values for each product. In the other columns there are sub-part numbers used to create the product in column 0, such as pdüse_e,s,b, but these values are not unique. the same sub-part may be used to make more than one product. And I have another table ;LQUA87 in this table there are stock values of all materials. In the MATNR column, the codes of the products and in the VERME column, the stock quantities are written.

This is what I want;
When I select the desired product from Pdüse_0 with the help of a slicer, I want to see the stocks of sub-parts used in the production of this product as a column chart.

I can match MATNR columns with P_düse0, but it gives an error when I want to establish a relationship with other sub-part columns. Can you please help 😞

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Melissa27]

Thank you for your support I add sample data excel in post 🙂 Can you help me now please ?

[lbendlin]

Unpivot your data.

see attached.