IF statement in a measure which is ("n.a") when is equal to a condition otherwise is a number

[maryjanesmith]

Hi,
I have this condition about a customize table constructed with a switch statement:

if.eager(values('Rubricas Financeiras'[Rubricas])="% EBITDA","n.a",[Finance value YTD]-[Finnce Value Orç YTD])

But I received this error:
Error "Cannot convert type text "n.a" to type numeric"

Can you help, please?
Thank you!

[amitchandak · Accepted solution]

@maryjanesmith , if state both part should return same datatype . n/a is text

if.eager(values('Rubricas Financeiras'[Rubricas])="% EBITDA","n.a",([Finance value YTD]-[Finnce Value Orç YTD] )& "")

or

if.eager(values('Rubricas Financeiras'[Rubricas])="% EBITDA",blank(),([Finance value YTD]-[Finnce Value Orç YTD] ))

[v-jayw-msft · Accepted solution]

Hi @maryjanesmith ,

I failed to reproduce the scenario. I create a similar formula and it just works fine.

Measure 2 = IF.EAGER(SELECTEDVALUE(Table1[country])="US","n.a",SUM(Table1[sales]))

Check if you could set the format and data category as same as the screenshot below.

Best Regards,

Jay

[maryjanesmith]

@amitchandak I understand that but the client wants this message to appear. Is there any way to do that?
Thank you!

[amitchandak · Accepted solution]

@maryjanesmith , if state both part should return same datatype . n/a is text

if.eager(values('Rubricas Financeiras'[Rubricas])="% EBITDA","n.a",([Finance value YTD]-[Finnce Value Orç YTD] )& "")

or

if.eager(values('Rubricas Financeiras'[Rubricas])="% EBITDA",blank(),([Finance value YTD]-[Finnce Value Orç YTD] ))