How to create two different tables measures and relationships

[SelflearningBi]

I am new to Powerbi Please help me out 

I got two tables, one is the master table with all of the complated list of 2022 season order list( order qty, order value, model number, comment and so on) and the other one is delay table in which contains the amount of impacted quantity, reason of delaying, dealy weeks and so on.

I would like to see what percntage quanity of this season is get impacted and the percantage of the reason. 

I think I need to do:   Table 1 order quantity  - Table 2 Impact quantity    to see how many of them is being impacted and also do the %  by   using  (Table 1 order quantity  - Table 2 Impact quantity ) / table 1 total order quantity

My thought:

I would like to build relationship between these two tables. since all the information is not unique, Once I build relationship, i feel like I can  only create many to many.  
Since I am going to create different slicers by using Comment, Female, Factory Name and supplier name. ( im going to distinct them one by one to create new table for each based on two of my tables)

I use this measure to create my pie chart. 

Impacted Qty % = DIVIDE([Impacted Qty],SUM('FW22_5 30'[Confirmed Quantity(Total)]))

But its only show table 2 information, which the delay quantty and the reason. I would also like to show those not delay quantity, which should be dominated most of my pie chart.

I would like to show this pie chart as well  for week of delay , on time is from table 1, and the rest is from table 2

@v-yalanwu-msft @amitchandak

[v-chenwuz-msft]

Hi @SelflearningBi ,

In power bi, the best structure is the star structure.

So, please create a table to via OrderIDTable = values('Table1'[OrderID]). Then create relationships between Table1 and OrderIDTable from many to one. And relationship between OrderIDTable and Table2 from one to many.

Best Regards

Community Support Team _ chenwu zhu

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