Can't refer to column in SEARCH function DAX

[Anonymous]

Hi,

I'm having trouble creating a variable in measure with the SEARCH function because it doesn't detect the column I'm trying to reference. I've changed the column type to TEXT but it still doesn't work.

Any help would be appreciated. Thank you!

[parry2k]

@Anonymous you should understand the difference between Measure and calculated columns in case you don't know it already. There are many posts on it.

[Anonymous]

@amitchandak @parry2k Hi, I understand that I need to use an aggregation but I'm trying out a solution from the web and they can directly reference the table. Why can't I replicate what they did?

https://community.powerbi.com/t5/Desktop/Count-cells-starting-with-text-or-containing-text/m-p/11714...

[amitchandak · Accepted solution]

@Anonymous , he is using column not measure , that is what I got from the post

[Anonymous]

You're right. Thank you for pointing that out!

[amitchandak]

@Anonymous , A measure can take measure or aggregated column , so what you can do is

put this in filter

if(isblank(Countx(filter(findingdetails,search("O",findingdetails[Answer],,0)>0), findingdetails[Answer])) ,0,1)

or

if(Countx(filter(findingdetails,search("O",findingdetails[Answer],,0)>0), findingdetails[Answer])+0 =0 ,0,1)

[parry2k]

@Anonymous you are create measure and you cannot use column directly in a measure, it has to use with some aggregation.

change 'FindingDetails'[Answer] to MIN('FindingDetails'[Answer] )

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡