Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cannot apply VALUE on FILTERed table

Hello all,   Context I have a table with a column named "Answer" I want to measure the average of all numerical answer. Because, see, some answer are numerical and some answer are textual, but b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Nick,

 

I understand that you can't mix data type.
But one should be able to convert the rows of a filtered table only right?

 

I don't want to change the query because, I will need to realize different measures from the non-numerical answers in the future.

And then I would have to change the query again to filter what I want.. it's unpractical.

 

I could create a column and convert non-numerical answer to numerical answer by changing the scale, but I want to avoid touching the data as much as possible here.

I want to encapsulate the whole complexity of this operation (which is not very complex actually.. ) in the DAX measure.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I dont think you can change the data type via a measure.  But what if you add the following as a custom column to your query?

 

Then just a measure of:

Avg of Numerical = AVERAGE(Table1[Custom] )