How to write COALESCE with condition?

Helo Community,

I am trying to write down formula using DAX COALESCE function and I am getting below error.

“Expressions that yield variant data-type cannot be used to define calculated columns.”

How do I write below formula?

Coalsec =

var Good='A&I'[% Price Up or Down]>0.010000 && 'A&I'[Active / Inactive] = "Active"

var Poor='A&I'[% Price Up or Down]>=0.000000 && 'A&I'[% Price Up or Down]<=0.009999 && 'A&I'[Active / Inactive] = "Active"

var result=

COALESCE(Good,Poor,"No Impact")

return

result

Thanks