Forum Discussion
Solved
Filter Column based on two string options
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
Hii,
Does this work?
NewColumn = CALCULATE(DISTINCTCOUNT(table[ID]),FILTER(table,CONTAINSSTRING(table[OPTIONS],"String01")||CONTAINSSTRING(table[OPTIONS],"String02")))
Hope this helps.
4 Replies
Hii,
Does this work?
NewColumn = CALCULATE(DISTINCTCOUNT(table[ID]),FILTER(table,CONTAINSSTRING(table[OPTIONS],"String01")||CONTAINSSTRING(table[OPTIONS],"String02")))
Hope this helps.
