Cannot apply VALUE on FILTERed table

Hello Daniel,

Here you have a sample.

My goal is to have the average of all the numerical values.

Please note there are no empty Answer value in the filtered table, I checked it.

You do have empty rows in the full table though, that's the key element here.

I found a turnaround for this problem and I changed the query as suggested, in order to filter the 'Answer' column and format it prior to doing any DAX.

It work fine.. but I don't want to do this. I want to be able to filter it with DAX.

Given what I said earlier, it seems that the VALUE() function doesn't apply on my filtered table.. but on the full table, which have empty values.

If you have any other solutions I'm willing to hear it.

Have a nice day