Forum Discussion

cklopper's avatar
cklopper
Frequent Visitor
5 years ago
Solved

Alternative syntax to CONTAINSSTRING using Direct Connect to SSAS

What alternative DAX syntax can I use to CONTAINSSTRING when connecting to a tabular model using SSAS?   I want to define a measure that counts the number of accounts containing a specific string. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

cklopper , Alternative for CONTAINSTRING might be FIND.

Meanwhile, you can use the following DAX:

 

Original DAX:

CALCULATE(Account[Total Count Account Codes],

CONTAINSSTRING(Account[RegionalAccountClass],"abc" ) ||
CONTAINSSTRING('Account'[RegionalAccountClass] = "xyz"))

 

New DAX:

 

CALCULATE(Account[Total Count Account Codes],
OR(
CONTAINSSTRING(Account[RegionalAccountClass],"abc" ),
CONTAINSSTRING('Account'[RegionalAccountClass], "xyz")
)

 

 

 

cklopper's avatar
cklopper
Frequent Visitor
5 years ago

Anonymous, amitchandak thanks for the suggestions. Unfortunately CONTAINSSTRING doesn't work because I'm connected directly to SQL Server Analysis Services. It's not available as a function and PBI Desktop won't recognise it... 😞