evaluate
1 Topic
CONTAINSSTRING in EVALUATE error
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.Solved1.6KViews0likes6Comments