Help with POWER BI formula

[Syndicate_Admin]

hello community, I hope you are well... I have the following query:

when performing the formula that I copy below, it throws me error, when the column has no value or is blank, I do not realize that I have done wrong, I hope your help please.

CC3_Neumáticos =

var Noapplica = calculate(average('AD_Neumáticos'[CC3. Rolling folder without oversizing material or potholes. (Object) Objective of the control:• To have tracks in good condition to avoid exposure and/or contact of the tires with ...]),filter(ALLSELECTED('AD_Neumáticos'[CC3. Rolling folder without oversizing material or potholes. (Object) Objective of the control:• To have tracks in good condition to avoid exposure and/or contact of the tires with ...]),not(isblank('AD_Neumáticos'[CC3. Rolling folder without oversizing material or potholes. (Object) Objective of the control:• To have tracks in good condition to avoid exposure and/or contact of the tyres with ...]))))

return

if(isblank(Notapplic),"Not applicable",Not applicable)

Thank you!

[amitchandak]

@Syndicate_Admin , can you paste the error here. by clicking on that you will get the error.

Also share complete formula

[Syndicate_Admin]

This is the error message:

[v-yiruan-msft · Accepted solution]

Hi  @Syndicate_Admin ,

What is the data type of the field referenced by the AVERAGE function? Based on the error message, it looks like you are using a field with TEXT type to calculate the average... Therefore, make sure that the field used to calculate the average is of a NUMERIC type. If its data type is numeric and you still get such an error message, please provide some sample data(exclude sensitive data) applied to the visual where the error message appears. Thank you.

Best Regards