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