Regarding Conversion of Number to a Text in measure column

[ramshoney1225]

Hi I have a requirment, i have a table with 

Name , Country, count

Count is a numeric type which holds count of order per name..

In my Count column there is ( -9999) or ( 9999 ) values which can consider one case -9999 or 9999 I'm considering 9999

Now i need to create a measure like when ever i see 9999 it should show as "NA" in the report and other it shows it values.

Please help

Thanks,

[ramshoney1225]

I tried with Measure and Calculated column, both are throwing error.

[Samarth_18]

Hi @ramshoney1225 

You can create a measure with below code:-

Measure = IF(MAX('Table'[count]) = 9999, "NA",MAX('Table'[count]))

Output:-

My table data:-

Thanks,

Samarth

[ramshoney1225]

Hi @Samarth_18 

Thanks for quick help. but I'm getting the below issue when using sample data

[Samarth_18 · Accepted solution]

Hi @ramshoney1225 

could you please use below code as it is, in your measure. 

M11 =
IF ( MAX ( 'Sheet1'[measure] ) = -9999, "NA", MAX ( 'Sheet1'[measure] ) )

Thanks,

Samarth

[ramshoney1225]

Hi @Samarth_18 

Thanks for the quick help. Issue resloved the above logic.

In hurry i missed the ")" brace in the Max (   = )  🤣