Forum Discussion
Solved
Search text DAX not working
Dear All, I am trying to perform an if test on a column that contains strings. After searching the web, I decided to use the search function. I keep running in an error telling me that a singl...
Is home accounts{acc_name] already a calculated column?
Try this one as a column
test = IF(IFERROR(SEARCH("Transient Retail",'home accounts'[acc_name]),-1)=1,10,0)
Are you creating a column or a measure ?
it is a measure. I tried creating a calculated column but the operation that follows the if statement creates a circular reference.
Is home accounts{acc_name] already a calculated column?
Try this one as a column
test = IF(IFERROR(SEARCH("Transient Retail",'home accounts'[acc_name]),-1)=1,10,0)
it works when creating a column :)
why does it fail when creating a new measure then?
Because needs a row contex to work. When you try as a measure tries to read the whole column .