Forum Discussion
AndyB87
6 years agoNew Member
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 p...
- 6 years ago
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"})
amitchandak
6 years agoSuper User
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"})
- AndyB876 years agoNew Member
Yes! These measures work beautifully. Thank you!