"NA" converts to na in measure

[Jojo197]

I have a matrix visual, with a single measure determining the values shown below. I can't seem to reproduce the issue with a simplified example, but in the following code, when MainTable[SectionHeader] (at the bottom) is the string "NA", the string "na" gets displayed on the matrix instead. I think this is due to some new update on power bi, as it was working perfectly fine previously. I've been able to fix it by adding on " " onto the end of each value, but it isn't exactly an elegant solution, and I was hoping someone in the community might have a better explanation/solution for me.

Value = IF([Hide],BLANK(),IF(HASONEVALUE(DimCategories[Code]),
    SELECTEDVALUE(FactArchive[ValueFinal]),
    IF(CALCULATE(
        COUNTA(FactArchive[ValueFinal])=0,
        ALL(FactArchive),FactArchive[Code] in VALUES(DimCategories[Code]),
        DimHeaders[HeaderBU]=SELECTEDVALUE(DimHeaders[HeaderBU])
    ),BLANK(),SELECTEDVALUE('MainTable'[SectionHeader]))
))

[amitchandak]

@Jojo197 , There is no NA used in the measure.

You can have a calculation like

Value = IF([Hide],BLANK(),IF(HASONEVALUE(DimCategories[Code]),
SELECTEDVALUE(FactArchive[ValueFinal]),
IF(CALCULATE(
COUNTA(FactArchive[ValueFinal])=0,
ALL(FactArchive),FactArchive[Code] in VALUES(DimCategories[Code]),
DimHeaders[HeaderBU]=SELECTEDVALUE(DimHeaders[HeaderBU])
),"NA",SELECTEDVALUE('MainTable'[SectionHeader]))
))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.