Custom column - Average excluding "NA" values

Use something along the lines of:

Measure = AVERAGEX(FILTER('Table',[Yellow]<>"NA"),[Yellow])

Option 1: As pointed out use filter in your query

Option 2: Default value to 0 when blank or NA occurs that way your regular calculation would work.

Hi Anonymous,

Based on my test, you could refer to Greg_Deckler's solution, also, you could refer to replace the 'NA' value in query editor:

Hope it could help you.

Regards,

Daniel He