Filter Column based on two string options

[KPME]

Hello everyone,

for one string filter the following works: 

NewColumn = CALCULATE(DISTINCTCOUNT(table[ID]),FILTER(table,CONTAINSSTRING(table[OPTIONS],"String01")))

However for two strings I tried this (but doesn't work):

NewColumn = CALCULATE(DISTINCTCOUNT(table[ID]),FILTER(table,CONTAINSSTRING(table[OPTIONS],"String01"+"String02))))

Kind regards

[Ashish_Mathur · Accepted solution]

Hii,

Does this work?

NewColumn = CALCULATE(DISTINCTCOUNT(table[ID]),FILTER(table,CONTAINSSTRING(table[OPTIONS],"String01")||CONTAINSSTRING(table[OPTIONS],"String02")))

Hope this helps.

[Jayee]

Hi @KPME 

For the second column use AND (&&), OR (||) operator insted of "+" sign based on your requirement 

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[KPME]

Hey! this doesn't result in any errors, however it does result in an error in the visual which I can't explain 😞 

[Jayee]

may be you can provide sameple data without sensitive information so i can able to support you further.