how to show "N/A" for a measure if the expression has a Null value

[cseward1963]

this is the expression, sum(Billed)-Before(sum(Billed))

I hope someone can help.

[sunny_talwar · Accepted solution]

May be this

Alt(Sum(Billed)-Before(Sum(Billed)), 'N/A')

[sunny_talwar]

Or this

If(Len(Trim(Sum(Billed)-Before(Sum(Billed)))) = 0, 'N/A', Sum(Billed)-Before(Sum(Billed)))

[cseward1963]

ALT function worked - THANK YOU!