Forum Discussion
Calculating Average Among groups
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!
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"})
2 Replies
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"})Yes! These measures work beautifully. Thank you!
