Forum Discussion

Ayush_tiwari08's avatar
Ayush_tiwari08
Helper I
3 years ago
Solved

IF condition is not working for string values

HI i am trying to apply some conditions on string columns but i am getting wrong results 

these are the conditions i am applying on measures

1- IF(CONTAINSSTRING(MAX('Cynoteck (Performance)'[Value - string]),"Review"),"Review Needed","Not")

2- Review Needed = IF(MAX('Cynoteck (Performance)'[Value - string])="Review","Review Needed","Review Not")

In both the case i am geeting output as "Review not" & "Not"whereas there are values inside [value-string ] column which are = "Review" i am unable to understand why i am geeting wrong output

 

 

Need Help
  • Manoj_Nair's avatar
    Manoj_Nair
    3 years ago

    Ayush_tiwari08 - try this DAX 

    Review Needed = IF(COUNTX(FILTER(Cynoteck,CONTAINSSTRING(Cynoteck[Performance],"Review")),Cynoteck[Performance])>0,"Review Needed","Review Not")

    OR

    Review Needed 2 = if(CALCULATE(Count(Cynoteck[Performance]),CONTAINSSTRING(Cynoteck[Performance], "Review"))>0, "Review Needed", "Review Not")

     

    If this answers your query, pls Accept as Solution 

4 Replies

  • Manoj_Nair's avatar
    Manoj_Nair
    Solution Supplier
    3 years ago

    Ayush_tiwari08 - try this DAX 

    Review Needed = IF(COUNTX(FILTER(Cynoteck,CONTAINSSTRING(Cynoteck[Performance],"Review")),Cynoteck[Performance])>0,"Review Needed","Review Not")

    OR

    Review Needed 2 = if(CALCULATE(Count(Cynoteck[Performance]),CONTAINSSTRING(Cynoteck[Performance], "Review"))>0, "Review Needed", "Review Not")

     

    If this answers your query, pls Accept as Solution 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Ayush_tiwari08 Sorry, having trouble following, can you post sample data as text and expected output?
    Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

    Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.

    • Ayush_tiwari08's avatar
      Ayush_tiwari08
      Helper I
      3 years ago

      Hi 

      Sample Data 

      Value- String (Column datatype - ABC)
      Review
      Review
      Review
      0
      1

      4

      Exceeded
      These are the values inside the column now i want to visualise a card which will show the alert if the coulm has values "Review"

      So i used above mentioned Dax formula but it is giving me wrong results