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 ...
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 

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 

Ayush_tiwari08's avatar
Ayush_tiwari08
Helper I
3 years ago

Thankyou so much manoj it worked.