Calculate Average in a column including text string

[jinweitan]

Hi all,

I have a table in my Power BI Report

Name	Score
John	10
Sue	20
Kelly	-

and what I want to make it into is as following:

Name	Score
John	10
Sue	20
Kelly	-
Average	15

I've tried using quick measure, but it says that it is unable to calculate as the column contains type string.

Hope to get some advice here.

Many thanks.

[amitchandak · Accepted solution]

@jinweitan , Create a new column like this and use that

new Score =if([Score] ="-",blank(),[Score]) //Change data type as whole number