Forum Discussion
Solved
Getting syntax error when calculating average
Wherever I try incorporating a calculation with excluding blanks, I get Syntax error. Quite frustrating! For instance- I am trying to calculate average of a clumn which has number of questions as...
Hello roger360,
Can you please try this approach:
AverageNumberOfQuestions = CALCULATE( AVERAGE(TrackerData[Number of questions]), FILTER( TrackerData, NOT(ISBLANK(TrackerData[Number of questions])) ) )Hi,
Blanks do not impact an average calculation. This simple measure should work
AverageNumberOfQuestions = AVERAGE(TrackerData[Number of questions])Hope this helps.
Hello roger360,
Can you please try this approach:
AverageNumberOfQuestions =
CALCULATE(
AVERAGE(TrackerData[Number of questions]),
FILTER(
TrackerData,
NOT(ISBLANK(TrackerData[Number of questions]))
)
)
Thats perfect Sahir_Maharaj ...thanks.
Do you mind giving me a quick reason why my previous one showing that error?