How to calculate average of weight,hight and kinetic joule

[carebear88]

Hi!

I need some help in order to calculate the average value of some of my data. Most Power BI tips are related to sales and therefore I have not managed to find any help for my problem.

I need to calculate the average of the following values;

Weight

Hight

kinetic Joule

I want to see these in the context of years. For example is the weigth of the items increasing this year ( by acerage) compared to last year? and so on.

I have a table with similar data like this

weight   hight  kinetic joule

 5            3,5       40

 2,3          4         1809

( dont mind the data in this example, it is just random selected numbers to show you)

Is there a simple dax function that I can use with this data? I hve tried the AVARAGE fuction but it dosent seem to work with this kind of data. 

Is this because my data does not only contain whole numbers?

Thank you so much for your help!

[rbriga]

Yes, AVERAGE requires numerical values.

- Clean up your data: make sure the values in each column contains only numbers, and in the same unit (though you can work around unit conversions)

- Do you have 3 columns: weight   hight  kinetic joule, or are those values all in one column? The former is much preferable and can be easily created in PowerQuery.

If you need more help, please include a screen shot of your source table headers and a few rows for example.