Nested if with Istext is not working

[Lakshmi1294]

Hi All,

I have a Column contains Values and Text in Same column I want to Compare monthly values with Monthly goal but both columns contain Values and Text. i want to present numbers and text both in Table visual with applying Conditional formatting.

For that I'm trying to create one conditional Column by giving below logic

Ex:-if (istext([Goal]),1,

        If(isblank([Goal]),Blank(),0)

But it is returning only 1  and Blank values not returning false condition that is 0 

Can anyone please help me out in this

Thank you in advance 🙂

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[DataNinja777]

Hi @Lakshmi1294 

I just modifed the dax formula for the culculated column and the below syntax procuces your required output.