https://pragmaticworks.com/guides/dax-guide/aggregate-functions/dax-guide-count/averagea
AVERAGEA - Mixed Data Types in a Column
Returns the average (arithmetic mean) of all the numbers in a column. Handles text and non-numeric values.
data typesaverageamixedcolumn