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 

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