Search if text conatins a value in column B for a fixed value in columns A

[nadrayazaji82]

Hello all! i am trying to check if columns B contains "Virus" or "Malware" and returns True or false for every device.. i am just trying to run through a list of computers to see which one is missing Antivirus.

hoping to get the results like

DeviceID	AV Check
1	TRUE
2	FALSE
3	TRUE

[msornakumar · Accepted solution]

Hi ,

  Please try the below measures

AVCheck Measure = CALCULATE(COUNTROWS(Device),SEARCH("Virus",Device[Installed],1,FALSE()) || SEARCH("Malware",Device[Installed],1,FALSE()) )

AvCheck = if(ISBLANK(Device[AVCheck Measure]),"FALSE","TRUE") 

[Anonymous · Accepted solution]

Hi

 You can add the conditional columns in Query editor as shown below and then you can filter as you needed.

Kindly note that the filter values are case sensitive.

[msornakumar · Accepted solution]

Hi ,

  Please try the below measures

AVCheck Measure = CALCULATE(COUNTROWS(Device),SEARCH("Virus",Device[Installed],1,FALSE()) || SEARCH("Malware",Device[Installed],1,FALSE()) )

AvCheck = if(ISBLANK(Device[AVCheck Measure]),"FALSE","TRUE")