Forum Discussion

vbourbeau's avatar
vbourbeau
Icon for Resolver II rankResolver II
6 years ago
Solved

Average of average

Hi, I want to do something probably easy but I don't figure it out.  I have a mesure that is an average of value. When I do a table and regroup, the average always remains on all the data but I wan...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    vbourbeau ,Try like

    averagex(Summarize(Table,Table[id],"_1",average(Table[Value])),[_1])
vbourbeau's avatar
vbourbeau
Icon for Resolver II rankResolver II
6 years ago

Same result

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

vbourbeau ,Try like

averagex(Summarize(Table,Table[id],"_1",average(Table[Value])),[_1])