Change blank word to not applicable in report

[Syndicate_Admin]

Hi all, I have the following query... I currently have the following formula:

CC1 = calculate(average('AD_Perforación'[CC01 - Access ramps to yards built and maintained according to standard. (Conduct or act) Objective of the control:• Operate on ramps built and enabled for the dimensions of the equipment...]),filter(ALLSELECTED('AD_Perforación'[CC01 - Access ramps to the patios built and maintained according to standard. (Conduct or act) Objective of the control:• Operate on ramps built and enabled for the dimensions of the equipment...]),not(isblank('AD_Perforación'[CC01 - Access ramps to the patios built and maintained according to standard. (Conduct or act) Objective of the control:• Operate on ramps built and enabled for the dimensions of the equipment...]))))

but I need to add to the formula so that the word "blank" does not appear, otherwise, that it appears "does not apply"

Thanks a lot

[aj1973]

Hi @Syndicate_Admin 

You need to nest your measures into IF formula:

IF(ISBLANK(yourformula) , "N/A" , yourformula)

[Syndicate_Admin]

thanks for the answer, I apologize but I am a bit of a beginner, can you help me where to locate the formula that has given me in my formula?

Thank you

[aj1973 · Accepted solution]

Try this

CC1 =
VAR _CC1 =
CALCULATE (
AVERAGE ( 'AD_Perforación'[CC01 - Access ramps to yards built and maintained according to standard. (Conduct or act) Objective of the control:• Operate on ramps built and enabled for the dimensions of the equipment...] ),
FILTER (
ALLSELECTED ( 'AD_Perforación'[CC01 - Access ramps to the patios built and maintained according to standard. (Conduct or act) Objective of the control:• Operate on ramps built and enabled for the dimensions of the equipment...] ),
NOT (
ISBLANK ( 'AD_Perforación'[CC01 - Access ramps to the patios built and maintained according to standard. (Conduct or act) Objective of the control:• Operate on ramps built and enabled for the dimensions of the equipment...] )
)
)
)
RETURN
IF ( ISBLANK ( _CC1 ), "Not applicable", _CC1 )

Cpoy/Pate it and Let me know

[Syndicate_Admin]

I appreciate your time for the answer, I struggled to understand by the translation, but now I work.