Average measure in power BI

[MostafaGamal]

Hi All,

If i have set of values ( 1, 2 , 2 ,4 ) i want to make a measure to take an average without decimal ( i mean the value to be 2 not 2.25 and so on ) 

[camargos88]

@MostafaGamal ,

Try this measure:

_Avg = INT(AVERAGE('Table'[Column1]))

https://docs.microsoft.com/en-us/dax/int-function-dax

[MostafaGamal]

@camargos88  thanks it works fine but it converts 3.75 to 3 i want it to convert it to 4 ( the nearst value above or below ) 

[camargos88 · Accepted solution]

@MostafaGamal ,

Try this one:

_Convert = ROUND(AVERAGE('Table'[Column1]), 0)

https://docs.microsoft.com/en-us/dax/round-function-dax

[MostafaGamal]

@camargos88 it gives me the same result 

[camargos88]

@MostafaGamal ,

[MostafaGamal]

@camargos88 it give me this 

[camargos88]

@MostafaGamal ,

Can you send me the values ?

[MostafaGamal]

@camargos88  this measure will work on a large set of data the values in the data are ( 1,2,3,4 ) the this values will be repeated every day at least 100 

And I want the average to be the nearest value 

If it 3.7 to be 4

If it 3.2 to be 3 

[camargos88]

@MostafaGamal ,

I don't think it depends on the number os values, on it's the average.

See the documentation about this function:

[MostafaGamal]

@camargos88  that's what I'm trying to say that the set of values I use right now will not affect the average 

Do you think there is an error in the formula or I use it wrong ? 

[camargos88]

@MostafaGamal ,

Try with these values:

1,2,2,4,8,5.5

It should return an average of 3.75...with the measure should be 4.

[MostafaGamal]

@camargos88 thanks it works now