Forum Discussion

Lakshmi1294's avatar
Lakshmi1294
Frequent Visitor
3 years ago

Nested if with Istext is not working

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 🙂

Help

2 Replies

  • DataNinja777's avatar
    DataNinja777
    Icon for Super User rankSuper User
    3 years ago

    Hi Lakshmi1294 

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

     

  • technolog's avatar
    technolog
    Icon for Super User rankSuper User
    2 years ago

    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.