measure to get the average of values

[MostafaGamal]

Hi All,

I have a SP connected to a PBI report, I want to  create a measure that get the average of values in a column and rounds it to the nearest integer number 

for example if the average is 2.7  it will rounds it to 3 

if the average is 2.3 it will rounds it to 2 

[AlexisOlson · Accepted solution]

Using ROUND and AVERAGE should work fine.

Rounding to 0 decimal places:

ROUND ( AVERAGE ( Table1[ColA] ), 0 )