Forum Discussion

AndyB87's avatar
AndyB87
New Member
6 years ago
Solved

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...
  • amitchandak's avatar
    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"})