Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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 , 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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |