topic Re: CONTAINSSTRING in EVALUATE error in DAX Commands and Tips

CONTAINSSTRING in EVALUATE error

Anonymous — Wed, 06 Dec 2023 12:24:29 GMT

Hey guys.

I'm trying to pull data from SSAS in Import mode using DAX Query. But having trouble with CONTAINSSTRING in EVALUATE statement. No matter how I change it, it gives me error every time.

EVALUATE

FILTER(

ALL( 'Task'[appointment_type] ),

CONTAINSSTRING( [appointment_type], "Callcenter" )

)

The error I get is following:

DataSource.Error: AnalysisServices: Query (4, 5) Failed to resolve name 'CONTAINSSTRING'. It is not a valid table, variable, or function name.

Any ideas?

IN operator also doesn't seem to work in EVALUATE statement.

Re: CONTAINSSTRING in EVALUATE error

BeaBF — Wed, 06 Dec 2023 13:41:15 GMT

Anonymous Hi! Try with:

EVALUATE
FILTER(
ALL( 'Task'[appointment_type] ),
CONTAINSSTRINGEXACT( 'Task'[appointment_type], "Callcenter" )
)

BBF

Re: CONTAINSSTRING in EVALUATE error

Anonymous — Wed, 06 Dec 2023 13:50:55 GMT

Thx for your reply.

I don't see how a very similar function would make a difference. Anyway, it doesn't work.

Re: CONTAINSSTRING in EVALUATE error

BeaBF — Wed, 06 Dec 2023 13:53:01 GMT

Anonymous you're right. Have you tried with the SEARCH?
EVALUATE
FILTER(
ALL( 'Task'[appointment_type] ),
SEARCH("Callcenter", 'Task'[appointment_type], 1, 0) > 0
)

BBF

Re: CONTAINSSTRING in EVALUATE error

Anonymous — Wed, 06 Dec 2023 13:59:34 GMT

Yes, I've tried different solutions and I can get it work. That's not the point here, though. I want to know why not all DAX functions work in DAX Query, what I'm missing.

Re: CONTAINSSTRING in EVALUATE error

BeaBF — Wed, 06 Dec 2023 14:04:26 GMT

Anonymous DAX queries in Analysis Services mainly incorporate a limited set of DAX functions, and not all the functions found in Power BI or Power Pivot are accessible within DAX queries.

The capabilities provided in DAX queries are influenced by the version and compatibility level configured for your Analysis Services instance.

Re: CONTAINSSTRING in EVALUATE error

Anonymous — Tue, 12 Dec 2023 08:21:35 GMT

Perfect. That's what I was looking for. Thank you!