Forum Discussion

DionTN's avatar
DionTN
Helper II
4 years ago

Calculate average from table

I have a table with calculated fields. Now i need the average of those calculated fields:

So the first one needs to be 6.6 and the second 7.05.

 

I tried this without succes:

Gemiddelde van GemiddeldeLichaamssamenstellingEerste per AppointmentId = 
AVERAGEX(
	KEEPFILTERS(VALUES('usermeasurements'[AppointmentId])),
	CALCULATE([GemiddeldeLichaamssamenstellingTweede])
)

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    4 years ago

    DionTN Try this measure:

    CALCULATE(AVERAGE(TableName[Numeric Column Name]),ALLEXCEPT(TableName,TableName[AppointmentID]))

     

    • DionTN's avatar
      DionTN
      Helper II
      4 years ago

      Tahreem24 

      This is not working because I need the average of the calculated numbers: GemiddeldelichaamssamenstellingEerste and GemiddeldelichaamssamenstellingTweede. So its not a column in a table.