Calculate Average of text Values in power bi

[Anonymous]

Hi

I need to calculate average for the number of orders that have been placed under different industries. However, the orders are VARCHAR values. Can someone advise how i can do that? 

[lbendlin]

create a measure that uses VALUE() or change the column type.