Forum Discussion
AutoJL
Helper II
Helper IIFiltering out only numeric values for an AVERAGEX
Hi everyone, I need to filter out only numeric values of a column in order to do a proper AVERAGEX but I am failing horribly to do so and i dont know why. This is what my data looks like: ...
AutoJL , If only NO_BARCODE is text then try like
Average number of inputs = AVERAGEX (FILTER(Samples,Samples[SampleID] <> "NO_BARCODE"),Samples[Number of inputs])
Otherwise explore in power query
Split Column By Digit to Non Digit & Non Digit to Digit: https://youtu.be/tY4Yk1crS9s
amitchandak
Super User
Super UserAutoJL , If only NO_BARCODE is text then try like
Average number of inputs = AVERAGEX (FILTER(Samples,Samples[SampleID] <> "NO_BARCODE"),Samples[Number of inputs])
Otherwise explore in power query
Split Column By Digit to Non Digit & Non Digit to Digit: https://youtu.be/tY4Yk1crS9s