Calculate average of calculated table

[DionTN]

I have a table with averages. Now i want to have the average of the averages in another table and fill the row.

So in the last table i need 7.63.

The function i use is:

Kolom = IF(webgraph[Category] = "Lichaamssamenstelling", var a = AVERAGE(calctable[BodyComp2]) return a)

Anyone who can help me?

BTW, I also need to do this for other rows. So I need to add elseif webgraph[Category] = "Cardio" a=average(calctable[cardio2])

[amitchandak]

@DionTN , Usually when need avg or Avg in Grand total Assume body Comp2 is an average measure

AverageX(values(Table[FullName]), [body Comp2])

[DionTN]

@amitchandak  Unfortunately still got the 7.31. Used this function:

Kolom = IF(webgraph[Category] = "Lichaamssamenstelling", AVERAGEX(VALUES(calctable[Fullname]),[BodyComp2])