Add % value to rate without formatting using measure

I am trying to add % symbol to the interest rate values from an excel source (since the column contains percentage values without % symbol in excel).
But on using the below measure, which is formatted as percentage, I'm getting the values only in some rows, other rows have blank values(highlighted).

Interest Rate  measure= AVERAGEX(table1,DIVIDE(SELECTEDVALUE(table1[interest_rate]),100))

How can I change this measure to give values correctly for all the rows?