DAX help calculating average based on other columns

[Anonymous]

In this scenario, I am trying to use the average from column "ABC Bid per KGs" per column "Route" and column "Weight Range".

I want to take the average from ABC Bid per KGS and apply it to the rows where ABC Company Bid = "N"

For the rows where ABC Company Bid = Y and are the same Route and Same Weight Range I want the average.

Then take this average where ABC Company Bid = "Y" and apply to the rows where ABC Company Bid = "N" for the same Route and same Weight Range

Goal of comparing the winning rate to  average rate to see how the rates would have compared if bid upon.

IE - apply average rate of $8.62 to any row where Route is the same and Weight Range is the same.  Order # 7, 11, 16, etc

IE - apply average rate of $4.31 to any row where Route is the same and Weight Range is the same.  Order # 3, 8, 10

ABC Company Bid	Order #	Company Name	Route	Order Count	KGs	Weight Range	Winning Rate per KGs	ABC Bid per KGs	Average Rate per Route and Weight Range
N	7	Company 6	Germany to Mexico	1	120	100 plus	$13.08
N	11	Company 8	Germany to Mexico	1	200	100 plus	$24.50
N	16	Company 11	Germany to Mexico	1	320	100 plus	$24.66
N	17	Company 13	Germany to Mexico	1	345	100 plus	$11.95
N	12	Company 8	Germany to Mexico	1	400	100 plus	$7.75
N	9	Company 7	Germany to Mexico	1	419	100 plus	$7.10
N	13	Company 8	Germany to Mexico	1	467	100 plus	$8.35
N	3	Company 5	Germany to Mexico	1	542	500 plus	$5.84
N	8	Company 7	Germany to Mexico	1	599	500 plus	$5.38
N	10	Company 7	Germany to Mexico	1	934	500 plus	$3.91
N	15	Company 11	Germany to Mexico	1	2288	1000 plus	$6.11
N	4	Company 6	Germany to Mexico	1	4224	1000 plus	$3.98
N	6	Company 6	Germany to Mexico	1	4576	1000 plus	$4.06
N	5	Company 6	Germany to Mexico	1	6160	1000 plus	$3.67
Y	44	Company 9	Germany to Mexico	1	48	50 plus	$55.33	$26.21
Y	46	Company 12	Germany to Mexico	1	70	50 plus	$48.30	$34.49
Y	42	Company 8	Germany to Mexico	1	177	100 plus	$10.79	$10.16	Average = $8.62
Y	37	Company 5	Germany to Mexico	1	268	100 plus	$8.38	$11.02	Average = $8.62
Y	27	ABC Company	Germany to Mexico	1	406	100 plus	$4.68	$4.68	Average = $8.62
Y	31	ABC Company	Germany to Mexico	1	753	500 plus	$3.00	$3.00	Average = $4.31
Y	21	ABC Company	Germany to Mexico	1	800	500 plus	$5.62	$5.62	Average = $4.31
Y	40	Company 7	Germany to Mexico	1	990	500 plus	$4.70	$4.30	Average = $4.31
Y	34	ABC Company	Germany to Mexico	1	1402	1000 plus	$4.34	$4.34
Y	33	ABC Company	Germany to Mexico	1	1426	1000 plus	$2.96	$2.96
Y	28	ABC Company	Germany to Mexico	1	1500	1000 plus	$4.64	$4.64
Y	23	ABC Company	Germany to Mexico	1	1566	1000 plus	$4.44	$4.44
Y	25	ABC Company	Germany to Mexico	1	1566	1000 plus	$3.27	$3.27
Y	36	Company 4	Germany to Mexico	1	1699	1000 plus	$4.94	$4.77
Y	24	ABC Company	Germany to Mexico	1	1901	1000 plus	$2.50	$2.50
Y	32	ABC Company	Germany to Mexico	1	2063	1000 plus	$3.00	$3.00
Y	18	Company 1	Germany to Mexico	1	2063	1000 plus	$3.71	$3.12
Y	20	ABC Company	Germany to Mexico	1	2851	1000 plus	$2.53	$2.53
Y	43	Company 8	Germany to Mexico	1	3347	1000 plus	$3.91	$3.12
Y	26	ABC Company	Germany to Mexico	1	3915	1000 plus	$2.31	$2.31
Y	19	Company 2	Germany to Mexico	1	4016	1000 plus	$3.80	$4.04
Y	38	Company 6	Germany to Mexico	1	4016	1000 plus	$3.83	$2.98
Y	39	Company 7	Germany to Mexico	1	4161	1000 plus	$5.28	$4.38
Y	35	ABC Company	Germany to Mexico	1	4601	1000 plus	$2.87	$2.87
Y	22	ABC Company	Germany to Mexico	1	5354	1000 plus	$3.65	$3.65
Y	41	Company 7	Germany to Mexico	1	5440	1000 plus	$4.95	$3.04
Y	29	ABC Company	Germany to Mexico	1	7226	1000 plus	$2.33	$2.33
Y	30	ABC Company	Germany to Mexico	1	12390	1000 plus	$2.50	$2.50