Calculating Average Among groups

[AndyB87]

This seems like a pretty straight-forward operation, but I'm fairly new to working with data, so I don't know how to proceed. I have a table showing amino acid content for three recipes of the same product-type from a food brand. I want to create a table that returns the average of each amino acid group for two recipes in each column.

So for example, I want one column that shows the average Isoleucine, Tyrosine, and Lysine for recipes A and B in one column, recipes A and C in another, and recipes B and C in the third. I'm sure this problem has been solved before, but I couldn't find it. I would appreciate it if someone could point me in the right direction!

Here's what I'm starting with (values have been simplified for this example):

Amino Acid	Recipe	Value
Isoleucine	A	1
Phenylalanine-Tyrosine	A	1
Lysine	A	1
Isoleucine	B	2
Phenylalanine-Tyrosine	B	2
Lysine	B	2
Isoleucine	C	3
Phenylalanine-Tyrosine	C	3
Lysine	C	3

And here's the result I want:

Amino Acid	AB Average	AC Average	BC Average
Isoleucine	1.5	2	2.5
Phenylalanine-Tyrosine	1.5	2	2.5
Lysine	1.5	2	2.5

Thanks!

[amitchandak · Accepted solution]

@AndyB87 , Will this kind of measure work for you

AB Average	=calculate(average(Table[Value]),table[Recipe] in {"A","B"})
AC Average	=calculate(average(Table[Value]),table[Recipe] in {"A","C"})
BC Average=calculate(average(Table[Value]),table[Recipe] in {"C","B"})

[AndyB87]

Yes! These measures work beautifully. Thank you!