Need help to find correct relationship to bill of materials dashboard

[EugenioProlog]

I have two products that are called "Kits", which are made using "Parts". The parts needed for each kit are on my "bom" table. 
I have a fact table with the price of each part per month.
I need to build a dashboard that calculates the cost of each Kit (sum each part cost * ammount needed), then, I need to create a tooltip when I hover over the data, showing a detail with: a table with each item cost, item price, item price on previous month, and Delta (%) between months.
I tried to create this structure below but it did not work at all. Here is my file below attached: 
https://drive.google.com/file/d/12_fFy0qZlmqoqEhaxcu_K4Tpf4ppCFr-/view?usp=sharing

Here is a visual idea of what i want to build:
https://drive.google.com/file/d/1amOGrzy5RqPtGZmE05-n36iYp7HpNGQG/view?usp=sharing

[v-ssriganesh]

Hello @EugenioProlog,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[Ashish_Mathur]

Hi,

It will help if you share the download link of an MS Excel file with your working there.  I will understand those formulas and translate them into DAX measures.

[v-ssriganesh · Accepted solution]

Hello @EugenioProlog,
Thank you for posting your query in the Microsoft Fabric Community Forum.

Create two relationships (Kit = active, Part = inactive) and activate the correct one in DAX using USERELATIONSHIP, or

Avoid ambiguity by using TREATAS inside the measure to map part_id to dim_items[item_id]. Once this is done, you can safely place dim_items[item_name] on rows instead of bom[kit_id].

Thanks, @GeraldGEmerick for sharing valuable insights.

[EugenioProlog]

Thank you for your answer!

I still have this question: how can I put the dim_items[item_name] on the rows instead of the bom[kit_id] column? the problem is that I can't find a way to create a relationship between dim_items and bom because both kit_id and part_id from the bom table are in my dim_items table. 

[GeraldGEmerick]

@EugenioProlog You can form a relationship between the two tables within a measure. However, I am not certain what exactly you are trying to achieve. If you put item_name on the rows is that with kit_id or without it and what kind of calculation are you going for?

[GeraldGEmerick]

@EugenioProlog Take a look at the revised Power BI Desktop file attached and see if that meets your needs.