Forum Discussion
Search text DAX not working
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)
Sorry my mistake, it was missing one parethesis after your column name
try this
test = IF(IFERROR(SEARCH("Transient Retail",'home accounts'[acc_name]),-1)=1,10,0)
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)
no problem :)
it is a tough one. I tried a lot of things before asking for help.
Your new solution return the following error:
There must be an issue with the column in the table but it does not make any sense to me. the snapshot of the account table shows that the column Acc_name does exist and the text we are searching for is in that column!!
I dont really know what to do.
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.
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 .